avg days (DAY WISE)

[Anonymous]

Hi all pls find the attached App,My requirement is to get the mention result days wise.

Thanking You

Vinayagam

[MK_QSL]

=SUM(TOTAL <Centre,State> PO)/COUNT(TOTAL <Centre,State> DISTINCT Date)

[Anonymous]

Thanks Sir

But if u see the subtotal at state level it shows its different

[arthur_dom]

COULD BE THIS?

=avg ( AGGR (SUM(TOTAL <Centre,State> PO)/COUNT(TOTAL <Centre,State> DISTINCT Date) , Date, Centre, State))