Web intelligence Multivalue error

[ShootingStar]

Hello there,

i have a problem with counting the number of instances from a variable that i have created in a webi document.

i've made the variable "Compliance" in order to get the compliance level of every incident recorded using the following formula :

= If [Urgency] = "Low" And [Duration] >= 27 Then "B"

ElseIf[Urgency] = "Medium" And [Duration] >= 18 Then "B"

ElseIf [Urgency] InList("High";"Critical") And [Duration] >= 4 Then "B" Else "C"

the above variable work's ok & can display the compliance level for every incident item, however, when i try to count the number of breached items "B", i get #MULTIVALUE error.

below is the formula used to count the number of instances as a result of that variable:

=Count ([Incident ID]) Where([Compliance]="B")

Please help to overcome this issue.

[ShootingStar · Accepted solution]

i was able to resolve this problem by including "Where" operator to the scope of Count function & adding forEach to the end of the formula syntax so the new Count function will look like this : =Count([Incident ID]Where([Compliance]="B") ForEach([Incident ID]))