Formula Value | Community

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!

Page 1 / 1

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?

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.

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

Reply