Bruce, Finally I got the problem,
My calculated control is running in a panel, I make it hide when the form loads. On click of a check box I make it visible.
If don't do the above hide and unhide thing, it works. It seems either the calculated control does not work on hide mode or the item value control doesn't trigger the change event.
Anyway managed to achieve the result with conditional calculation
Yes hiding it removes it from runtime which then causes it not to show. Glad you figured that out.
Shoutout to Bruce Altner for his guidance on this also. Great job community.
Help with my percentage calculation on Nintex Form.
I have the following formula:
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)
ok then, just did not want to open new section each time I ask a question.
Although it seems that my question is more or less the same as here.
Never mind, created new subject: https://community.nintex.com/message/59691-help-with-percentage-calculation-calc-field
I'm going to pose my question here because I'll probably just get pointed back to this thread if I start a new one.
My calculation is all messed up. Why can't it handle values 100.00 and over?
yea, I ended up figuring it out. This is the same thing I left out with another calculated value I posted previously. You'd think I would learn. :\
Please I need your help on this, Now I have 2 text box in Nintex forms
If user type or change value in Textbox1 less than <1,000,000 ---- textbox2 value will be "Incidental".
If user type or change value in Textbox1 between (1,000,000 -10,000,000) ---- textbox2 value will be "Minor".
If user type or change value in Textbox1 between (10,000,000 -20,000,000) ---- textbox2 value will be "Moderate".
If user type or change value in Textbox1 between (20,000,000 -100,000,000) ---- textbox2 value will be "Major".
If user type or change value in Textbox1 greater than (>100,000,000) ---- textbox2 value will be "Severe".
I try calculated value to do this , when I use calculated value form not showing when I try to add new item , I try to add rule also this is not helpful.