Average of the last 8 days

[poojashribanger]

Hi All,

I want to calculate average of last 8 mondays or tue so on and leaving current monday sum.same for all weekdays

and then replace that average with all the mondays or tue or fri so on in a table

Please help

Thanks,

[sunny_talwar]

I don't think you have provided me with the correct output... look at this.... I would have expected to see 45.5

But you seem to have calculated like this

Did the requirement changed or is that an error?

Also, how is average 1 here? There is no previous date... shouldn't this be Null?

[poojashribanger]

Hi,
sorry my bad,
output which you have provided is correct.
if there is no previous date then same value will replicate as average.
I tried to to this and succeeded for last 8 days ,but it is not calculating for previous dates

Thanks,

[sunny_talwar]

Sorry I was not clear before, but can you please provide the updated output file with the correct numbers. This will help me verify if I am getting the right numbers across the board.

[poojashribanger]

Sure,

Please find Attachment.