Forum Discussion
IIF formula not working...
I am struggling with something that should be simple: In a custom Organization Field I need to put this formula: iif(Csng([Lavoro])>0,(CSng([Costo]) / CSng([Lavoro]) * CSng([Lavoro Definitivo...
Yes, John, my mistake.
[Lavoro Definitivo] is of type duration, being a "Work"
[Costo Definitivo] is of type Cost
Final Formula should be:
IIf (csng([Lavoro])>0, (csng([Costo]) / csng([Lavoro]) * csng([Lavoro Definitivo])), 0)
it didn't work, anyways, until I wrote the condition with the right blank characters in the right places...
IIf (csng([Lavoro]) > 0,......
it seems weird to me, but syntax has its rules, as far as I can see.
Thank you!
Emanuele175,
Are you saying it now works after you inserted spaces in your formula? If so, I've NEVER seen that before. In fact, when I inadvertently include extra spaces in a formula, they are automatically deleted.
John
Are you saying it now works after you inserted spaces in your formula? If so, I've NEVER seen that before. In fact, when I inadvertently include extra spaces in a formula, they are automatically deleted.
John