Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
i am calculating AVG for Using this Expression
=sum(pay_amount)/count(distinct standard id])
in list box i have three business how can i write separate expression each one
BusinessUnit1-----i want to show each business AVG separate
Business Unit2---Where can i apply this business Filter in Expression
Business Unit3---
Thanks In Advance
Niranjan
Write like
1. =sum ({<YourListBoxfield = {' BusinessUnit1 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit1 '}>} standard id])
2. =sum ({<YourListBoxfield = {' BusinessUnit2 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit2 '}>} standard id])
3. =sum ({<YourListBoxfield = {' BusinessUnit3 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit3 '}>} standard id])
Something like:
sum(Aggr(pay_amount,Business1))/count(Aggr(distinct standard id], Business1))
Write like
1. =sum ({<YourListBoxfield = {' BusinessUnit1 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit1 '}>} standard id])
2. =sum ({<YourListBoxfield = {' BusinessUnit2 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit2 '}>} standard id])
3. =sum ({<YourListBoxfield = {' BusinessUnit3 '}>} pay_amount)/count(distinct {<YourListBoxfield = {' BusinessUnit3 '}>} standard id])