Key Figure Duplication Problem in Webi Report
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,