Skip to main content

Help with my percentage calculation on Nintex Form.
I have the following formula:

(Expenditure-PlannedExpenditure)/PlannedExpenditure*100

The results shown as this:

 

The above results are correct (note the decimal places is set to 0 for the percentage).

 

However, if the planned expenditure is NULL than the percentage is logically infinite, right?
In this case, in the form it is shown as 0% but in the actual SharePoint table the field remains blank.

 

 

Using the same approach in Excel; it shows an error:
Note if I use *100 on excel, the percentage does not round to 0 decimal.

 

 

 

Question is; how to modify my current formula on Nintex Form (calculated field)
so that it calculates the percentage as seen in the first 2 pictures but also shows 100% when Planned Expenditure is 0 (zero)

 

 

ThankYou

UPDATE - ISSUE SOLVED

In case someone needs this:

if(PlannedExpenditure==0,"100") || (Expenditure-PlannedExpenditure)/PlannedExpenditure*100

This runs the IF statement and then the || stands for OR

it works the way I wanted to happy.png


Reply