Forum Discussion

AshleySolomon's avatar
AshleySolomon
Qrew Trainee
2 years ago
Solved

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...
  • TylerFoster's avatar
    TylerFoster
    2 years ago

    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.
    ------------------------------
TylerFoster's avatar
TylerFoster
Qrew Cadet
2 years ago

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.
------------------------------