AnsweredAssumed Answered

How to compare a calculated field value with a number value

Question asked by ramsam on Jan 5, 2018
Latest reply on Jan 8, 2018 by ramsam

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

Outcomes