Skip to Content
0
Jun 05, 2018 at 08:34 PM

Dimension formula from 7.5 to 10.1

146 Views

Hi,

I need to rewrite this member formula from 7.5 to 10.1 standard:

I tried to create a member formula for the bold part, and then in options I have created a record for the function for DaysInAllPeriod (saved in LGF file and uploaded to system in UJFS), but no help...

*Function CASDAYINV -([FINACCT].[APR10070],[MEASURES].[PERIODIC])/(( [FINACCT].[APR50150],[MEASURES].[R12]) / (DaysInAllPeriod))

*EndFunction

*Function DaysInAllPeriod iif( [TIME].CurrentMember.properties("LEVEL")="MONTH", iif( [TIME].CurrentMember.properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(1).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(1).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(1).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(2).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(2).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(2).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(3).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(3).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(3).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(4).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(4).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(4).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(5).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(5).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(5).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(6).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(6).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(6).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(7).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(7).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(7).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(8).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(8).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(8).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(9).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(9).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(9).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(10).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(10).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(10).properties("NO_DAY")= "42",42,0))) + iif( [TIME].CurrentMember.Lag(11).properties("NO_DAY")= "28",28, iif( [TIME].CurrentMember.Lag(11).properties("NO_DAY")= "35",35, iif( [TIME].CurrentMember.Lag(11).properties("NO_DAY")= "42",42,0))) ,364)

*endfunction