How to Calculate Average in a Break of WEBI Document ?

[former_member194503]

Hi Experts,

I have a Detailed level Data which I have displayed in a Break. so all measures automatically displayed as aggregated. I need a column which will display as Average. Kindly suggest any Syntax.

Data

Country          Revenue     No of Player

India               50000          11

India               30000          11

India               70000          11

China             600000         20

China               52346         20

Displayed in Break

Country          Revenue          No of Player

India               150000              33   <<<---------------------------------- Requirement is 11 (Which is the Average in place of Sum)

China               652346             40   <<<---------------------------------- Requirement is 20 (Which is the Average in place of Sum)

I have tried a syntax"         =(Average( [No of Player])In Break)      " but it is not working. It is  Displaying the Value "  (33+40) / 2  " in both the rows

[Former Member]

Can you please try the below formula

=Sum([No of Players])/(Count([No of Players];All)

Regards,

Amala.S

[amitrathi239]

Hi,

try this.

=Average(Sum([Players]))

or

=Average(Sum([Players])) In ([Country])

Amit

[former_member194503]

Hi Amit,

Thanks for ur quick respond but its not working

Any other sugessation ?

[amitrathi239]

Hi

share your table screenshot..no of players is a variale?

Amit

[former_member194503]

Hi,

Yes No of Player is a variable.

here is the screenshot below

[former_member221193]

Hi Babisri,

Use the above formula provided by Amit and add a dimension object which contains unique reference to Region Ship object in the report and hide it to get the desired results.

-Faiz

[Former Member]

Use database delegated as projection in universe

[arijit_das]

=Average([CREDIT TERMS (DAYS)]) did not work ?

[former_member194503]

Hi Faiz,

You are correct. I got it solved by using Amit's formula but by adding Unique referance in the formula itselh by using "In" Operator.

ie.

= Average([Object] In ([Referance Obj1];[Referance Obj2];[Referance Obj3]))

Thank you guys, Thank you all for your valuable Time.

Special Thanks to Amit who respond so early.Thanks a lot