Skip to Content
0
Former Member
Apr 29, 2015 at 06:20 PM

#multivalue Webi 4.1

57 Views

Hi,

I have a variable as below.

If monthnumber=1 then 177.14

Elseif monthnumber=1 then 337.14

Elseif monthnumber=1 then 514.28

else 0

Crosstab below in attachment.

var1 is a running sum for each month.

If user selects Month 1 in Input control. Amount/177.14...

If user selects Month 2 in Input control. Amount/337.14 and so on.

When I remove month from crosstab. I get #multivalue error. Please see attached.

Thank you!

Veena M

Attachments

#multivalue.PNG (11.1 kB)