numbers should equal
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 f...
Forum Discussion
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
- What are the field types for FieldA and FieldB? Sounds like they're not the same, so the values they're producing aren't the same until you convert them.
