Skip to main content
Nintex Community Menu Bar

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!

 

 

24875i5444237F96060F12.png24876iC83DF77D454E533A.png

 

 

Hi,

I tried to replicate this issue in my NWC Tenant but was not able to. It calculated as expected. Are you able to provide an export of your form?

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

 


Hello, export attached. Thank you!


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.

 

 


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