#multivalue Webi 4.1

[Former Member]

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

[Former Member]

I got the solution. Thanks!!!

[Former Member]

Hi Veena,

If you have read SCN rule of engagement properly then you would have close all your thread after getting your solution.

We as a member of SCN community would be very greatful if you do so by marking answer as correct.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

I don't see the option. Mark answer as correct.

Thank You

Veena

[tanveer1]

Hi Veena,

When you open this thread you can see two options below each comment Helpful answer Correct Answer.

Please select appropriate buttons to close this thread

Thanks,

Tanveer.

[Former Member]

Hi Tanveer,

I still don't see it.  I had the same issue with another question I posted.

Thanks

Veena

[tanisha_gupta20]

Hi Veena,

You should be able to see something like this below every answer. Please click the required option and close the thread so that it is helpful to others.

Regards,

Tanisha

[Former Member]

Hi Tanisha,

I think the problem is, I didnt mark this post as a question.  That's why I don't see the option to mark correct answer.

Thank You

Veena

[Former Member]

Hi veena,

BO will throw #multivalue error

as you are calculating Var1 value month wise and then you are removing month object #from context.

because of this BO will not be able to find values (exluding month).

So I would suggest you to keep month object as it is.

Or else tell me your extarct requirement so that I can help to find different approach

[tanveer1]

Hi,

You could either hide the Dimension Month. right click on the Month column > Hide >> Hide Dimension

or add ForEach(month) in your variable.

Thanks,

Tanveer.

[Former Member]

Hi Veena,

try adding a ForEach ([month])in your variable. Besides, your If variable only tests for monthnumber = 1 ? Is this correct ?

Regards,

Rogerio

[Former Member]

Hi Rogerio,

I included the foreach(month) in my variable. I still get #multivalue error.

Thank You

Veena