Forum Discussion
Else If Custom Column issue
Hey all, I am having an issue with my If statement in a custom Column. The below is suppose to give a percentage based on the total spend, but instead it just gives the first percentage of .1...
Anonymous
You will need to reverse the order of your else IF Expressions.
Once an if expression condition is met, it stops executing the rest of IF expressions.
So if your PretaxCharges are more than 100,000 they are also more tham 5000 as well
So this expression is executed since it appears first
if[PretaxCharges] > 5000 then .15
Anonymous
When i use some random data with your formula... I dont get 0.16 every time.
Yea I am confused on where the issue is here.
The top one should be .16 as it's below 5k but the others shouldn't be. I don't see what it's looking at, as it should just compare that spend with the if statements