Forum Discussion

DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago

Trouble comparing number values in formula field

Alright, so I have two tables, say Order Sheets and Order Items Each Order Sheet can have multiple Order items.  Each Order Sheet has a field labeled Order Amount Each Order Item has a Quantity...
APIs and custom code
Formulas and functions
Tables and fields
KevinSlider's avatar
KevinSlider
Qrew Trainee
7 years ago
This is where I would try converting to text.
If (totext(Round([Order Amount], .01)) <> totext(Round([Total Items], .01)), "Not Equal")

if this didnt work, I would be setting up a test formula to evaluate what the value is for 
totext(Round([Order Amount], .01)) and  totext(Round([Total Items], .01))

Let us know your progress.