If or Case formula for Calculation
I am trying to create a formula field with these guidelines: If or Case ([Total Points Wk 1] is less than 500, return value "0", 500-999 return value "1", 1000-1499 return value "2", 1500+ return va...
Forum Discussion
You will need to use a normal If() condition versus case based on the fact that you're comparing a range of values.
Your syntax would be like:
if(
[Total Points Wk 1]<500,1,
[Total Points Wk 1]<1000,2,
[Total Points Wk 1]<1500,3,
4)
I'm assuming your syntax issue might be because you have your 1,2,3,4 in quotes like "1", "2".
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
Your syntax would be like:
if(
[Total Points Wk 1]<500,1,
[Total Points Wk 1]<1000,2,
[Total Points Wk 1]<1500,3,
4)
I'm assuming your syntax issue might be because you have your 1,2,3,4 in quotes like "1", "2".
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
Perfect! Thank you :)