numbers should equal

Question

I have a CheckBox Formula field that compares Field A & Field B (If Round(FieldA,.01) = Round(FieldB,.01) then TRUE)

The Table is displaying Field A = 24.60 and Field B = 24.60 -- but my checkbox field = FALSE....

It is likely a rounding issue -- but I'm including the Round() function and still getting FALSE ---Any suggestions?

BradElmore · Answer

FYI:   I got this to work by converting to text --- ToText(Round(FieldA,.01)) = ToText(Round(FieldB,.01))  -- It works -- not sure it this is best practice -- any input is still appreciated

Sign up

Login to the community