Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Thanks Alot.

Tags:
Former Member
replied

Hi Ademola,

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.

Thanks,

Mahboob Mohammed

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question