You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OEP_FS Not taking Member Formula that ASO cube does

in Planning 2 comments

I have written this code for a member formula to take monthly values of an account with a running yearly total.

CASE
When (Is([Period].CurrentMember,[Jan]))
Then ([155265],[Jan])
When (Is([Period].CurrentMember,[Feb]))
Then ([155265],[Feb])-([155265],[Jan])
When (Is([Period].CurrentMember,[Mar]))
Then ([155265],[Mar])-([155265],[Feb])
When (Is([Period].CurrentMember,[Apr]))
Then ([155265],[Apr])-([155265],[Mar])
When (Is([Period].CurrentMember,[May]))
Then ([155265],[May])-([155265],[Apr])
When (Is([Period].CurrentMember,[Jun]))
Then ([155265],[Jun])-([155265],[May])
When (Is([Period].CurrentMember,[Jul]))
Then ([155265],[Jul])-([155265],[Jun])
When (Is([Period].CurrentMember,[Aug]))
Then ([155265],[Aug])-([155265],[Jul])
When (Is([Period].CurrentMember,[Sep]))
Then ([155265],[Sep])-([155265],[Aug])

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!