Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to get average of 1st and 2nd expression in the app.
avg(exp1/exp2)
Please help.
May be this?
Avg(Aggr((count({<Product = {"=sum(Sales)>0"}>}DISTINCT Product) / count(DISTINCT Product)), Category, Product))
May be this?
Avg(Aggr((count({<Product = {"=sum(Sales)>0"}>}DISTINCT Product) / count(DISTINCT Product)), Category, Product))
Hi,
may be try this,
=Num(count({<Product = {"=sum(Sales)>0"}>}DISTINCT Product)
/
count(DISTINCT Product),'#,##0%')
Hi,
Another simplest way like below
=Column(1)/Column(2)