Forum Discussion

AshleySolomon's avatar
AshleySolomon
Qrew Trainee
2 years ago

Numeric Formula with multiple conditions

HELP! I've racked my brain over this one.  I have a Numeric Total Field (Currency) that gets it's value via serval different possible options. 1st it looks at a Manual Entry Field. If the Manu...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

In Quickbase, there is a difference between a zero and a null.  I suggest that you go to the field properties for

[Domestic Wires (#) - Manual]

and you will probably see that these checkbox is enabled to treat blank as zero.  So deselect that.  That will be that blank is null and not zero. Then you can test with IsNull( ....)

If(not IsNull([Domestic Wires (#) - Manual]), 

[Domestic Wires (#) - Manual] * [Fee Schedule - Wire Fee (Domestic)],

[# of Domestic Wires (Snapshot)]*[Fee Schedule - Wire Fee (Domestic)],0)

Note that you don't need the clutter of those SUM(   ) functions.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------