COUNT Based on Condition of another Variable
Good Day Folks,
I was wondering if this is possible in Webi. I have a data set from which I would like to make the following Deductions:
Data Set is below:
Any suggestion would be appreciated.
Mahboob Mohammed replied
Try using an If Then Else statement to achieve this. What numbers does Average Mape show, is it 0.00 to 1.00 and you format it to show as Percent in the report? Lets start with the below formula and see what happens.
=If([Average Mape] In ([Product]) < 0.10) Then "Good"
ElseIf([Average Mape] In ([Product]) between (0.11;0.20)) Then "Bad"
ElseIf([Average Mape] In ([Product]) between (0.21;0.40)) Then "Ugly"
ElseIf([Average Mape] In ([Product]) > 0.40) Then "Terrible"
Let us know how this looks and what is it missing.