Linear forecast expression

[kunkumnaveen]

Hi,

     i have to show coming next three years(2017,2018,2019) of spend based up (2014,2015,2016) data?

let say i my sample is

                    Year              spend

                       2014              100

                       2015                200

                        2016                 70

how much     2017                  ?

will be  for       2018                   ?

                       2019                    ?\

how to write a linear expression .......

Thanks

[Anil_Babu_Samineni · Accepted solution]

Is this you are expecting?

Expression i used

If(Sum(Spend),Sum(Spend)

,Linest_M(TOTAL Aggr(if(Sum(Spend),Sum(Spend)),Year),Year)*Year

+Linest_B(TOTAL Aggr(if(Sum(Spend),Sum(Spend)),Year),Year))

[kunkumnaveen]

Hello Anil, thanks for your reply,

but i am not getting what you got..

i used this

load * inline

[

Fyear,fspend

2014,100

2015,200

2016,70

2017

2018

2019

];

i am not geeting 2017,2018,2019...Why?

[kunkumnaveen]

i have done a mistake now i realise it Year field i need to change

[Anil_Babu_Samineni]

You can use Fyear instead of Year and then look

[kunkumnaveen]

Hello Anil,

               i wrote below expression in Line Style , so that those years will display in dots,

if(fspend>2016 ,  '<S3>')

but some how this is not working ,can u say wat i am missing  plz

[Anil_Babu_Samineni]

There is no wrong on your expression, Seems working to me