+2
I have a formula the sometimes requires a negative value.
For instance the sum in Agreement Value the original value, plus the previous value, and the negative "this" value needs to be $1,709,000 not -$141,000.
How do I edit the formula to accommodate a negative value and provide the correct sum?
This is in production so I need to ensure it will not affect any other active calculations.
Using Nintex WF Cloud and a Nintex for SharePoint 365
Thanks!
Best answer by Garrett
View original
+22
+16
Hi @johnreece
Seems like it the Previous Value was omitted out (to get the -141,000)
I got $1,709,000.00
Can you try with 2 more sample values and share the screenshots of the result?
Cheers
+2
Hello, export attached. Thank you!
+2
These are the two others reported; the first one is 17325; confirming the issue with 17329 on my end.
A total of three formula errors were reported.
+16
Hi @johnreece
Found the Issue. Its the Form Rules
Once the field "Agreement Value" get a negative value, the recalculation will NOT occur.
How to Resolve
I suggest the following solution - Update the Form Rule
IF ORIGINAL isFilled or PREVIOUS_VALUE isFILLED or THIS_VALUE isFILLED
THEN AGREEMENT_VALUE value sum(...)
ELSE AGREEMENT_VALUE value = 0
Screenshot
Tested. Verified working. However you should conduct your own detailed Testing.
Cheers
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.