Nintex for SharePoint Forum
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
Solved! Go to Solution.
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