I want a field to display one of two numbers - both of which are in caluclation fields called "Override Commission" and "Total Cycle Balance". I want it display the field that holds value. Only one of the fields will have a value, the other will = $0.00

So, i started with this calculation:

Case(

not IsEmpty(Override Commission), Override Commission,

not IsEmpty(Total Cycle Balance), Total Cycle Balance,

""

)

The problem is that my Override Commission Field is a calculation and when it ='s zero it displays $0.00 and is not empty. So this doesn't work. Any suggestions?

Personally I HATE calcs that are based upon two or more totally unrelated fields, which results in a case that could have multiple correct evaluations.

Case(

Override Commission > 0, Override Commission,

not IsEmpty(Total Cycle Balance), Total Cycle Balance,

""

)

Now what do you do if the Override Comission calc is greater than 0.00 and there is something in Total Cycle Balance? Just let Filemaker decide?

Case( Override Commission > 0, Override Commission, Case( Total Cycle Balance > 0, Total Cycle Balance, TextToNum("")))