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
How to scope result area dynamically in rule?
-
- Posts: 8
- Joined: Thu Feb 21, 2013 11:27 am
- OLAP Product: TM1, SAP BW
- Version: 9.5.2
- Excel Version: Excel 2010
-
- 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?
Sorry I get solution. Thanks
[ 'F000 Opening Balance' ,'2014.01' ] = N: IF(ATTRS('ACCOUNT', !ACCOUNT, 'ACC_TYPE') @= 'BS' , ['F999 Closing Balance', ' 2013.12' ] , STET);
[ 'F000 Opening Balance' ,'2014.01' ] = N: IF(ATTRS('ACCOUNT', !ACCOUNT, 'ACC_TYPE') @= 'BS' , ['F999 Closing Balance', ' 2013.12' ] , STET);