Using AVG in set Analysis

[sutoniusahadong]

Dear All,

Can help me, is it possible to run this script

=COUNT(DISTINCT {<Avg(BOBOT)={">3.05"}>} EMP_NO)

What alternative i can use ?

[HirisH_V7]

You can use if condition like,
If(Avg(BOBOT)>'3.05',
COUNT(DISTINCT EMP_NO)

i don't think set-analysis will work such way, will check anyway. You can do this avg in script and create a column. you can use the same in set analysis directly.

[sunny_talwar · Accepted solution]

Try this instead

=Count(DISTINCT {<EMP_NO = {"=Avg(BOBOT) > 3.05"}>} EMP_NO)

[HirisH_V7]

Cool 🙂 it working bro. @sutoniusahadong  you can use this & close thread.