Using the amount of last year for extrapolation this year

[#1]

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.

Thaanks in advance

[#2]

Hi,

Maybe something like this?

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

Regards,

Xue Bin

[#3]

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

[#4]

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:
LOAD * INLINE [
    Date, Customer
    01/01/2011, 40
    01/02/2011, 50
    01/03/2011, 60
];

finalTable:
LOAD
AddMonths(Date,12) AS PredictDate,
Customer*1.5 AS PredictCustomer
Resident tempTable;

Drop Table tempTable;

Regards,

Xue Bin

[jagan]

Hi,

Try this expression

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

Hope this helps you.

Regards,

Jagan.