Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Maybe something like this?
max( {$<Year = {$(#=Only(Year)-1)}>} Sales*1.5 )
Regards,
Xue Bin
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
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
Hi,
Try this expression
=Count({<Year={'=$(=(Max(Year) - 1))'}>} DISTINCT Customer) * 1.5
Hope this helps you.
Regards,
Jagan.