planning area setting to get average in monthly view

[Former Member]

Hi Experts

Need help to get correct average in the monthly view of planning book for key figure temperature 

info object  details are below

The average of month 8 is 22

The average of month 9 is 16.66

I am getting correct results in monthly book

But when data is missing / incomplete for some weeks , i am getting incorrect average

Please suggest if we can solve this with any standard setting in planning area  or info object

[Former Member]

i can only think of only alternate solution ,

Calculating the average using a macro and storing in another KF.and hide this KF in monthly view ,