Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

Error using if condition

hi,   i am getting the below error, can you help me?  
Need Help
Show and Tell
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
6 years ago

vjnvinod 

if(condition1&&condition2), you need to remove the if I highlighted in the below screenshot.

 

 

If you want to sort in order, you create a new table, column 1 order :1,2,3; column two values(like(>$25M). Create relationship with the fact table and order table.

Or you can add the order number in the formula. "1. >$25M"