SAP BO WEBI Formula For #MULTIVALUE

[former_member210724]

Dear Experts,

I need some suggestion for my WEBI formula:

We have to build a dashboard based on BO WEBI report.

Source of data for WEBI report is Relational universe.

We have build relational universe on ECC tables for specific scenarios.

My question is related to WEBI formulas:

I have data as shown below:

Transaction  status  Date                       Moth

T1                   1     01 -02-2014      02-2014

T2                   0     01-02-2014      02-2014

T3                   1     02-02-2014      02-2014

T1                   2     01-01-2014      01-2014

T1                   1     01-02-2014     02-2014

T2                   1    01-02-2014      02-2014

T1                   0         01-02-2014 02-2014

T3                   0     02-02-2014     02-2014

T2                   1     01-02-2014     02-2014

T1                   1     01-02-2014     02-2014

T3                   2     01-02-2014    02-2014

I am expecting an Output :

T1  with status 1 on date 01-02-2014 in my scenario I want to compare with current date for time being the current date is 01-02-2014

Transaction Stat_1_count

T1                      3

T2                      2

T3                    0

It would be grate if I get some suitable formula, I have tried using count/sum functions with where/ForEach Claus getting  #MULTIVALUE issue when I put a dimension in the table drill down.

i.e. if I display only the count variable I am getting right value ,when I bring Transaction on table I am getting .

Thanks/Best Regards

Anand T

[Former Member · Accepted solution]

you can use following formula:

= (count(status) where (status =1 ) in(transaction;status))in(status)

[former_member210724]

Hi Swapnil,

Grate ,I could able to get the required output, by applying your given formula.

thanks for the immediate solution.

with the help of above clue I hope I can explore some more complicated stuff, which I suppose to.

Thanks once again .

Anand T.