TM1 Forum

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
) ;

Is this rule before the other rule in your rules file? Do you have a feeder written for this rule?

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

Thanks everyone, your posts helped me out and I got it to work