Moving Average (6 Period)

[Christiaan_Huizer]

hi @Jean-Claude_Siliato ,

I could not access the doc, but I copied the table and this is what I got

this is the code part, maybe the screenshots in my blog help you to see the logic.

thisTable.Sort(True(),sortBy: thisTable.Date).Filter(Date <= thisRow.Date).[Per Unit].Slice(-6).Average()

Cheers, Christiaan