Good afternoon FM community,
I'm fairly new to FM here (using Pro 14 with a hosted DB) and would like some help with a Calculation I'm trying to get correct. I have a field that will do a calculation based off other fields in the table.
Specifically I'd have Field A, B, and C in a Calculation looking something like this: ((Field A-Field B) x .01 )x 5 x Field C x 10,000 =
This Calculation works just fine but the issue we're having is when Field C does not have a value. The Calculation will return a 0. While this answer is correct, a "0" in this field actually means something different to the operators that use the database so I'm looking for a way for it to display nothing of the referenced field C is empty. Is this best done by an If or Case function? Thanks in advance for any help here!