numbers should equal

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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? 
Photo of rocketc

rocketc

  • 824 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of rocketc

rocketc

  • 824 Points 500 badge 2x thumb
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. 
Can I see your actual formula?
Photo of rocketc

rocketc

  • 824 Points 500 badge 2x thumb
 I got this to work by converting to text ---

ToText(Round(FieldA,.01)) = ToText(Round(FieldB,.01))