I have a requirement how to compare a field on the nintex form with a number value
here are the screen shots
I have a calculated value called Total Requested which is connected to a SharePoint field.
Now the requirement is
we have 3 levels of approvers if total requested is 10,000 or less level 1 should show up
If Total Requested is greater than 10,000 and less than 50,000 both level 1 and level 2 should show up
In the same way if the Total Requested is greater than 50,000 and so on all the three levels should show up
Please kindly help me out with this formula
Any hell much appreciated!!
Thanks in Advance!!!!
Solved! Go to Solution.
Based on your description, you shouldnt need the "or" functions for these rules. All you should need to configure will be the level for each of the panels IE for the second panel the rule should be configured to hide the control only if the value is less than 10000. This should be the same for Level 3 where you'll only need to have the control hidden if the value is less than 50000. Please see the below example of the second and third level rules:
In practice, this will hide the controls if they are under the defined thresholds.
Thank you for your prompt response!!
It worked...First when I saw your solution, I was little confused because I tried this formula too( in the past now it works) and it did not work.
Later I realized I did not name the calculated value and not using calculated value control in my formula. Instead I connected my calculated value to list field and using the field name in my form!!!
Any way I really appreciate for your response