This content has been marked as final. Show 3 replies
I want to create a trend line based on moving average. I created the following moving average formula which is woking fine, except for the periods after the last one which has a value, since it is considering, in this example, Sept, Oct, Nov and Dec as '0'.
Here's the formula I'm using:
=IF(vTipoInfo = 'Mensal',RANGESUM(TOP(sum(IF(ANO_EVO=ANO and MES_EVO <= MES,num(META_INDICADOR_EVO,'.###,'))), 1, ROWNO())) / ROWNO())
But the behavior I need is what I tried to show through the dotted line.
I look forward to reading your replies!