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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIn 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
------------------------------
