Skip to Content
avatar image
Former Member

Change in Periodic measure formula for April Month

Dear Experts,

I am having issues with periodic calculation for P&L GL's, periodic calculation is working fine for all other months except January & April. We follow April to March as Fiscal year.

When i checked the formula it is maintained as below-

MEMBER [MEASURES].[YTD] AS 'IIF(([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ"),-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])), ([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])))' SOLVE_ORDER=3

MEMBER [MEASURES].[PERIODIC] AS 'IIF(([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP") AND NOT ([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="TOTAL" OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="Q1" OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JAN" ), [MEASURES].[YTD]-([MEASURES].[YTD],[%TIME%].LAG(1)), [MEASURES].[YTD])' SOLVE_ORDER=3

So it can be clearly visible that JAN is maintained here so i guess it should be APR instead of JAN.

Requesting your expert opinion if we can change this in formula only.

Will this solve my problem or do i need to change something else too.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 22, 2016 at 06:28 AM

    I have answered this question number of times. PERIOD property has to be in line with fiscal, nor calendar! Calendar April has to be JAN in PERIOD etc...

    Add comment
    10|10000 characters needed characters exceeded