cancel
Showing results for 
Search instead for 
Did you mean: 

some acc measures should show negative(LEQ accounts)

pratap_varma
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/206cb499-990f-2c10-5aa8-84d891894...

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