Nz Function - Formula Help
I have a Formula Currency field "Total Filing Fee" that needs to preform the following function: Take the value entered in "Filing Fees - Manual". If the field is blank then check to see if "Char...
Hi Ashley!
Try this one out...If([Filing Fees - Manual]<>0, [Filing Fees - Manual],
If([Schedule - Charge Filing Fee?]=true, [Schedule Filing Fees (per Filing)]))
Hope this helps! Let me know if it gives you any trouble.
Thanks!
------------------------------
Tyler Foster
Associate Developer
Synctivate Inc.
------------------------------
