AVG

[NavinReddy]

Dear All,

I am Calculating Avg for based on Users,But users are repeating that's why im using Standard id
here im calculating User AVG Per Year
These two expression im using
But i am getting Different values ,Please correct some on where im wrong

=avg(aggr(sum(PAY_AMT),[Standard Id],(Month)))=581.15
=Sum( PAY_AMT ) /Count(TOTAL [Standard Id] )=530.45

Thanks In Advance
Niranjan

[MK_QSL]

Try DISTINCT instead of TOTAL

=Sum( PAY_AMT ) /Count(DISTINCT {1} [Standard Id] )

Or please provide sample file or apps.

[NavinReddy]

Hi Manish,

yes i tried but not working thank you

Regards,

Niranjan

[MK_QSL]

Can you provide sample data?

[NavinReddy]

Hi Manish,

please find sample data

S Id	Employee Name	P_AMT	Year
11765	H	230	2014 01
11765	H	56	2014 02
53150	S	892	2014 01
53150	S	12	2014 02
23203	A	457	2014 01
23203	A	20	2014 02
23748	I	562	2014 01
23748	I	406	2014 02

Regards,

Niranjan

[MK_QSL · Accepted solution]

Check enclosed file..

Let us have brief description about your requirements.

[NavinReddy]

Thanks so much Manish..