numbers should equal

  • 0
  • 1
  • Question
  • Updated 1 month 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

  • 814 Points 500 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of rocketc

rocketc

  • 814 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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,592 Points 50k badge 2x thumb
Can I see your actual formula?
Photo of rocketc

rocketc

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

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