List box

[NavinReddy]

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

[alexandros17]

Something like:

sum(Aggr(pay_amount,Business1))/count(Aggr(distinct standard id], Business1))

[its_anandrjs · Accepted solution]

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])