4 Replies Latest reply: Jun 11, 2012 4:19 AM by jagan mohan rao appala

# Using the amount of last year for extrapolation this year

Hello everybody,

I want to use the outcome of the past ( e.g. l-7-2011 )   for  prediction of 1-7-2012 by a formula  e.g   the amout of 1-7-2010 *1,5.

Anybody any idea how my epression should look like.

• ###### Using the amount of last year for extrapolation this year

Hi,

Maybe something like this?

max( {\$<Year = {\$(#=Only(Year)-1)}>} Sales*1.5 )

Regards,

Xue Bin

• ###### Using the amount of last year for extrapolation this year

Hoi Xue Bin

This is no working I´m afraid . As I understand it this will change the amount of the date in the past and is not resulting  for an estimated amount in the future.

What I mean is this:

Value in the past on 1-7-2011    50 customers

Estimated value in the future on   1-7- 2012    should be 50 customers *1.5 =  75 customers

• ###### Using the amount of last year for extrapolation this year

Hi,

Maybe you can try to add a prediction table when you are loading your data. Hope this can solve your problem. Not very sure what you are trying to do though. Are you doing some trend analysis?

tempTable:
Date, Customer
01/01/2011, 40
01/02/2011, 50
01/03/2011, 60
];

finalTable:
Customer*1.5 AS PredictCustomer
Resident tempTable;

Drop Table tempTable;

Regards,

Xue Bin

• ###### Re: Using the amount of last year for extrapolation this year

Hi,

Try this expression

=Count({<Year={'=\$(=(Max(Year) - 1))'}>} DISTINCT Customer)  * 1.5

Hope this helps you.

Regards,

Jagan.