Multivalue Error in Webi

[#1]

Hi All,

I have a table with data as shown below

Requirement is to show the sum of "weighted average_Var(2)" for each month for each person. (For every month, I should be aggregating the weighted average for a person, now it is showing in 2 lines since we have different "Days Interval_Var" value, I need to show in 1 line).

I tried to create a variable "Test 5" with formula as below

=Sum([Weighted Average_Var (2)]) ForAll ([Days Interval_Var]) In ([Month Name_Var])

Report layout should be as shown below: So, For every month, I have created a formula as below but I get multivalue error

=If(([Month Name_Var]="July");[Test5])

C

an someone please help me resolve this?

Thanks

Poojitha

[Tom_N8]

Hi Poojitha,

Why don't you simply create a cross table with your [Month Name_Var] on the horizontal, [Person] on the vertical, and [Test5] on the body axis?

This will also prevent you from having to define individual variables for each month...

Regards,

Tom