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