Hi,
I started seeing this error often , and upon looking into it, it looks like a problem with formula handling negative numbers
Let’s say i have 2 field i want to add up
Field A value = 1000
Field B value = -28
And i have a formula {{fieldA}} - {{fieldB}}, it will return this error as Field B is a negative
My problem is those field would contain 95% positive values, but in some cases , as intended, the number would be negative
In the example above i would expect the result to be 1028
Is there any way around that error, or a way to hide this error message for this case only?
Thx
Page 1 / 1
Dave,
Try putting {{fieldA}} - ({{fieldB}}) and see if that gets rid of the error message.
Thanks!
Amy
Thank you Amy, that worked!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.