AnsweredAssumed Answered

Calculation dependent on an empty field

Question asked by makj1 on Dec 8, 2016
Latest reply on Dec 9, 2016 by philmodjunk

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!