formula with multiple parameters

Question

Hello,

I have a check box that I need to automatically be checked if the value of the request is &gt;2500 and &lt;15000.&nbsp; I had this worked out fine with the formula:&nbsp;
Case([Total]&gt;2500,([Total]&lt;5000),true,false,)
However, I have been asked to add a third parameter....if the user is a particular person, their thresholds are different...I'm trying this formula below. However, the issue I'm running into is that, the box is being checked even if it is below 2500.
Case([DOC]="Sean Regan",[Total]&gt;2500,([Total]&lt;5000),true,false,Case([DOC]="Grafton Montgomery",[Total]&gt;2500,([Total]&lt;5000),true,false,Case([DOC]="Jeron Pearson",[Total]&gt;2500,([Total]&lt;15000),true,false,Case([DOC]="Jared Bernshausen/Brian Oesch",[Total]&gt;2500,([Total]&lt;15000),true,false,Case([DOC]="Jay McClain",[Total]&gt;2500,([Total]&lt;15000),true,false)))))

Please help!!

Brandy
------------------------------Brandy Nunes------------------------------

christopherwhea · Answer

Something like this should work, you'll just need to add the rest of your folks...
var number requestMin = 2500;
var number requestMax = Case([DOC],
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Sean Regan", 5000,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Grafton Montgomery", 5000,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Jeron Pearson", 15000
);
[Total] &gt; $requestMin and [Total] &lt; $requestMax------------------------------Chris Wheatley------------------------------

adamkrzyzanek · Answer

If you use user field, first check if providing name is what this field recognize. Maybe you need to compare it with mail (as when I convert User field totext() it shows mail address)

------------------------------
Adam Krzyzanek
------------------------------

Forum Discussion

formula with multiple parameters

2 Replies