AnsweredAssumed Answered

Case statement with out exact results

Question asked by walfwood on May 24, 2018
Latest reply on May 28, 2018 by beverly

I am trying to make a field to inform someone quickly and with an easy look if a calculation is over, short or balanced. I am having one issue, the calculation is looking at the third decimal and not seeing it as balanced.  It doesn't equal exactly 0. The Field Balanced is, in this scenario, 0.004. Even if I do data formatting, it still sees the 0.004.

Is there a way around this?

Thank you for any help.

 

 

Case (

Balanced  >  "0";"Over";

Balanced  <  "0";"Short";

Balanced = "0" ; "Balanced" )

Outcomes