Multivalue Error in WebI

building reports webintelligence
1

I am using Webi XIR2

My columns are:
Program Name, Client Count, Bed Count
x, 20, 20
y, 10, 10
z, 5, 5

So, actually my y includes two program names. Therefore, my bed count for y is showing #multivalue"

When I write a variable: sum ([bed count]) foreach ([program name]) … then my bed count column shows (bed count X client count)

if i write a variable: max (bed count) forall (bed count)… it shows correct numbers in whole bed count coulmn except in y row because there it shows only one of the program’s bed count (however y includes two program names inside it)

Help me with the query to get correct bed count for “y” row.

Thanks,
Vineeta

littledreamz2007 (BOB member since 2009-10-19)

2

Welcome to B :mrgreen:B

As you said with Sum() aggregation along with context operators you did it , right?

Why you need Max() with context??

Just to try change the operators precedence, you used them as In side make the as out side.


=Max(aaa forall(bbb))

Try different combinations…

Hope it helps you…,

Thanks

BOCP (BOB member since 2007-07-02)

3

Part of the problem here is not code-related at all. If you have two different programs, both named “y”, what do you expect BOXI to do with them? How can BOXI tell them apart? You have to remember that computers are really not very bright, and need very explicit instructions.

Do you happen to have some other code for programs that is unique? You might try adding that to the report. Or, find some way to change the program names so that one is “y1” and the other “y2.”

Lugh (BOB member since 2009-07-16)