Skip to Content
Former Member
Jun 10, 2011 at 11:52 AM

Key Figure Duplication Problem in Webi Report


Hi Experts,

I have a problem in creating a formula. Please find below the information.

Every Opportunity can have more than one Product Id

Opp Id Prod Id Revenue

Oppid1 Prodid1 10

Oppid1 Prodid2 10

Oppid2 Prodid1 15

Oppid3 Prodid1 20

If you see in the above table Revenue for Opp1 is shown as 10+10 =20 where as it should be 10 only(Duplication Error).

I have to calculate Total Revenue :


13.75 is shown instead of 45

If I calculate it as ,

Total Revenue = if(Count(product id) in(opportunity id)) >1; Revenue/ Count(product id) in(opportunity id);Revenue) , its giving me 13.75 (10101520)/4 but I want 45(1010)/21520.

Please help me if you have any inputs on this.

Thanks & Regards,

Bhargava Bommidi.