Expression

[NavinReddy]

Dear All,

i am calculating AVG for this Expression

=round(sum(pay_amount)/count(Distinct[standard id])) =100

its working fine But i want to calculate Month Wise ,i want to put one more filter

I am using this expression its not working

=round(avg(aggr(sum(pay_amount), [standard id],month)))=15

is it correct way or correct

But i want to calculate Distinct Standard Id like this

=round(avg(aggr(sum(pay_amount),Count(Distinct [standard id]),month)))

its not working please some one help me

i am struck here any help

Thanks in Advance

Niranjan

[MK_QSL]

Can you provide sample data?

[jonathandienst · Accepted solution]

Hi

I think this is correct:

round(avg(aggr(sum(pay_amount) / count(Distinct [standard id]), month)))

HTH

Jonathan

[NavinReddy]

Thanks you so much its working

thanks for quick help