Hi,
i hope you can help me with my dilemma…i am creating a report in BO Webi XI version; the goal is to get the total number of incidents whose Priority is P2, and the (MaximumAffectedUsers/MaximumTotalUsers) is greater than or equal to 25% (0.25) PER month…Here is the formula i am using:
=If ([IncidentPriority]=“P2 - High” And ([MaxOfNumberAgentsAffected]/[MaxOfTotalAgents])>=0.25) Then 1 Else 0
i will create a new variable which will count all the 1 on the said formula.
this is set as a dimension. but when i use it, i get #MULTIVALUE on other months (please see result below):
Jun-11 0
Jul-11 #MULTIVALUE
Aug-11 #MULTIVALUE
Sep-11 #MULTIVALUE
newbie here needs some help. thanks! 
chekwa (BOB member since 2011-08-19)