Challenge #3: Running Averages

[cindyrez]

Thanks for the practice with some more new tools, however I don't understand why the multi-row formula tool grouped by both RM Category and Name for the 3 month running average but only grouped by Name for the 6 month running average calculation.

[duskyjayant]

My submission of the Third Weekly challenge.

[PhilipMannering]

Solution Attached

[Sameera]

Spoiler

[rajenderk18]

Here is my solution. I didn't understand the solution provided with the question. It is not giving the output what is asked in the question.

Spoiler

[OnionKnight]

This is not the exactly same as the solution's output, but this should be fine.

[clmc9601]

My solution

[AlexHirstData]

Not perfect, but it's difficult to replicate the solution example without going the super long way round. The values here match, just not the format.

[TraceyD]

Hm - The solution values didn't always look right to me.  

[OwenBData]

Decided to impute, replace NULL with 0, Calculate averages, then put those values back to NULL. 

Spoiler