Discussions

Expand all | Collapse all

numbers should equal

  • 1.  numbers should equal

    Posted 05-09-2019 18:31
    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? 


  • 2.  RE: numbers should equal

    Posted 05-09-2019 19:00
    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


  • 3.  RE: numbers should equal

    Posted 05-09-2019 23:23
    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. 


  • 4.  RE: numbers should equal

    Posted 05-09-2019 19:01
    Can I see your actual formula?


  • 5.  RE: numbers should equal

    Posted 05-09-2019 19:06
     I got this to work by converting to text ---

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