Trend based on Moving average

[#1]

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

[prabhuappu]

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

[#3]

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

[#4]

Hi Prabhu.

Did you read my reply? I posted it in January.

Regards,

Marcelo