cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to compare a calculated field value with a number value

Jump to solution

Hi Team,

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!!!!

Labels: (2)
Tags (1)
Reply
3 Replies
Workflow Hero

Re: How to compare a calculated field value with a number value

Jump to solution

OOPS!!!

I mean Any HELP much appreciated

Thanks!!!

0 Kudos
Reply
Workflow Hero

Re: How to compare a calculated field value with a number value

Jump to solution

Hi Rams,

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. 

Reply
Workflow Hero

Re: How to compare a calculated field value with a number value

Jump to solution

Hi Dan,

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

Thanks!!!!

0 Kudos
Reply