Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
I think this is correct:
round(avg(aggr(sum(pay_amount) / count(Distinct [standard id]), month)))
HTH
Jonathan
Can you provide sample data?
Hi
I think this is correct:
round(avg(aggr(sum(pay_amount) / count(Distinct [standard id]), month)))
HTH
Jonathan
Thanks you so much its working
thanks for quick help