avg

[surajap123]

Hi All,

I want to get average of 1st and 2nd expression in the app.

avg(exp1/exp2)

Please help.

[Anil_Babu_Samineni · Accepted solution]

May be this?

Avg(Aggr((count({<Product = {"=sum(Sales)>0"}>}DISTINCT Product) / count(DISTINCT Product)), Category, Product))

[mdmukramali]

Hi,

may be try this,

=Num(count({<Product = {"=sum(Sales)>0"}>}DISTINCT Product)

/

count(DISTINCT Product),'#,##0%')

[devarasu07]

Hi,

Another simplest way like below

=Column(1)/Column(2)