How to scope result area dynamically in rule?

Post Reply
chonlanotr
Posts: 8
Joined: Thu Feb 21, 2013 11:27 am
OLAP Product: TM1, SAP BW
Version: 9.5.2
Excel Version: Excel 2010

How to scope result area dynamically in rule?

Post by chonlanotr »

Hi All
I'm new for TM1. How to scope result area dynamically?

[RESULT AREA] = N: [SOURCE]

I try to create rule for balance carry forward. It should be perform only Balance Sheet GL Account. How can I do it in TM1?

Thanks in advanced
chonlanotr
Posts: 8
Joined: Thu Feb 21, 2013 11:27 am
OLAP Product: TM1, SAP BW
Version: 9.5.2
Excel Version: Excel 2010

Re: How to scope result area dynamically in rule?

Post by chonlanotr »

Sorry I get solution. Thanks
[ 'F000 Opening Balance' ,'2014.01' ] = N: IF(ATTRS('ACCOUNT', !ACCOUNT, 'ACC_TYPE') @= 'BS' , ['F999 Closing Balance', ' 2013.12' ] , STET);
Post Reply