Hello,
I am trying to write a RULE where in my Planning version i have a calculation C=A*B but in Actual C is an input. However I want to be able to open up my planning version and see the ACTUAL overwrite the first three months. I have written code to have TM1 block out whatever months are considered ACTUAL in the planning version however what is happening is that the C=A*B calculation is calculating for the months that are ACTUAL in the planning version. I just want the Actuals to overwrite the calculation and only keep the calculation for the forecasted months. Any ideas? Hope this makes sense?
[ {'Original' , 'Intercompany' } , {'Planning', 'Planning Division'},'Value'] = N:
IF ( ATTRN( 'MonthYearFiscal', !MonthYearFiscal, 'End Date Value' ) < ATTRN( 'MonthYearFiscal', DB('Control', 'Current Actual Month' , 'String' ) , 'End Date Value' ) ,
['Actual'],
CONTINUE
) ;
Actual and Forecasting
- mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Actual and Forecasting
Is this rule before the other rule in your rules file? Do you have a feeder written for this rule?
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- Posts: 49
- Joined: Thu May 21, 2009 1:16 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: Actual and Forecasting
Hi hpansar,
If I read what you have written correctly...
I would write a STET rule for the actual version first.
['Actual','Value']=N:
IF (
ATTRN( 'MonthYearFiscal', !MonthYearFiscal, 'End Date Value' ) <
ATTRN( 'MonthYearFiscal',
DB('Control', 'Current Actual Month' , 'String' ),
'End Date Value' ),
STET,
CONTINUE
);
then the rules for the plan version follows.
Regards
JD
If I read what you have written correctly...
I would write a STET rule for the actual version first.
['Actual','Value']=N:
IF (
ATTRN( 'MonthYearFiscal', !MonthYearFiscal, 'End Date Value' ) <
ATTRN( 'MonthYearFiscal',
DB('Control', 'Current Actual Month' , 'String' ),
'End Date Value' ),
STET,
CONTINUE
);
then the rules for the plan version follows.
Regards
JD
-
- Posts: 17
- Joined: Fri Apr 19, 2013 6:50 pm
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Actual and Forecasting
Thanks everyone, your posts helped me out and I got it to work