on 03-24-2015 6:02 AM
Hi Team,
We need to create PeriodicNat and YTDNat where LEQ need to be shown in negative.
Currently, it is showing
Fixed Assets 100
Current Assets 50
Current liabilities 80
--------------------------
Reserves 70
This should actually be displayed for Accounting purposes in natural signage as:
Fixed Assets 100
Current Assets 50
Current liabilities (80)
--------------------------
Reserves (70)
Kindly suggest where to modify in the below measures, in order to show LEQ as negative
Case 1: Periodic formula for App1
IIF(NOT ([%ACCOUNTDIM%].PROPERTIES("ACCTYPE")="LEQ" OR [%ACCOUNTDIM%].PROPERTIES("ACCTYPE")="AST") AND NOT ([%TIMEDIM%].PROPERTIES("ISBEGINNING")="1"),[MEASURES].[YTD]-([MEASURES].[YTD],[%TIMEDIM%].LAG(1)),[MEASURES].[YTD])
Case 2: Periodic formula for App2
IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="INC",-MEASURES.[SIGNEDDATA],IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="EXP",MEASURES.[SIGNEDDATA],IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="AST",(MEASURES.[SIGNEDDATA],CLOSINGPERIOD([%TIMEDIM%].[%TIMEBASELEVEL%])),IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="LEQ",-(MEASURES.[SIGNEDDATA], CLOSINGPERIOD([%TIMEDIM%].[%TIMEBASELEVEL%])),-MEASURES.[SIGNEDDATA]))))
Thanks,
Vivek.
Hi Vivek,
If your requirement is only for the reporting purpose then you can achieve through formatting sheet using custom formats.
Take look at below thread it will give idea about custom format and also custom measure.
BPC Blogs - Enterprise Performance Management - SCN Wiki
not sure but i think when you are creating custom measure you just need ti give negative sign when account type is LEQ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.