Skip to Content
0

Change in Periodic measure formula for April Month

Nov 22, 2016 at 05:16 AM

30

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Nov 22, 2016 at 06:28 AM
0

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...

Share
10 |10000 characters needed characters left characters exceeded