SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

[Ahmad]

How can I create a KPI with a formula that contains the following: 

SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

i want the right formula that give me Total of average amount_granted group by approval date 

[shashidhar_sris]

Hi,

Please confirm do you have duplicate dates in your Approval Date column? or  could you please attach screenshot of the data?

Regards,

Shashidhar.S

[Ahmad]

Unique Approval Date for each row , there is no duplication

[shashidhar_sris]

Hi Ahmad,

I have tried the same on my dataset. Below are the attached screenshots for reference. 
 KPI1 & KPI2 both gives same result. But KPI1 is faster than KPI2 actually. If its not giving correct result, let me know.

Regards,

Shashidhar.S