Forum Discussion
Solved
Creating IF Statement Over Category
Hello All, I am running into an issue trying to write a measure/calc. column which is basically an IF statement that classifies items: Classification = IF([Sum] < 5000000 , "<$5M", IF([Sum] ...
Hi,
Share some data and show the exact expected result in a Table format. Once the Table format is ready, we can switch to a Pie visual.
Ashish_Mathur - Will prep the sample data, but before that, I noticed that my IF or Sqitch statement both are working weirdly. So for the first condition which is checking if the [Sum] is less than 5000000 (5M) it's still putting values which are over 5M in that bucket for some reason. The data type of the [Sum] is set to Decimal Number which in itself I find crazy to occur.