Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear colleagues.
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!
Regards,
Marcelo
Hi Marcelo,
Is the data available for Oct, Nov and Dec months or you are trying to find forecast values.
Please upload some sample application if possible.
Regards,
Prabhu Appu
Hi Prabhu.
Thank you for the reply!
I'm trying to find forecast values. About uploading some same application, I'm not able to.
I look forward to hearing from you again.
Regards,
Marcelo
Hi Prabhu.
Did you read my reply? I posted it in January.
Regards,
Marcelo