cancel
Showing results for 
Search instead for 
Did you mean: 

#multivalue Webi 4.1

Former Member
0 Kudos
88

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

I got the solution. Thanks!!!

Former Member
0 Kudos

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
0 Kudos

Hi Swapnil,

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

Thank You

Veena

tanveer1
Active Contributor
0 Kudos

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
0 Kudos

Hi Tanveer,

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

Thanks

Veena

tanisha_gupta20
Participant
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

Hi Rogerio,

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

Thank You

Veena