MDX Formula not working if member value is missing
Summary
MDX Formula not working if member value is missingContent
Hi Gurus,
I am working on to calculate total rolling year
If its 2016 December ...its should calculate previous12 months including 201612(so 201612+201512+201511+201510.....etc 12 months)
but if 201612 data is missing its not summing up the values even we have the values for jun2016 and july2016
no issue if we have the data for the current member..
My hierarchies are YEAR->QTRS->Months->weeks
CASE WHEN IsLevel([Time].CurrentMember, 0) AND ( [Time].CurrentMember.Parent <> [Time].CurrentMember.Lead(1).Parent) AND ([Time].CurrentMember <> Missing)
THEN
sum(MemberRange ([Time].currentmember.Parent,[Time].currentmember.Parent.Lag(11)))
WHEN IsLevel([Time].CurrentMember, 1) AND ([Time].CurrentMember , Missing)
0