同比计算:
Iif (
IsEmpty((ParallelPeriod([时间].[年-月].CurrentMember.Parent.LEVEL, 1, [时间].[年-月].CurrentMember), [Measures].[销售数量]))
OR IsEmpty([Measures].[销售数量])
OR (ParallelPeriod([时间].[年-月].[年], 1, [时间].[年-月].CurrentMember), [Measures].[销售数量]) = 0
OR [Measures].[销售数量] = 0
OR ([时间].[年-月].CurrentMember.LEVEL IS [时间].[年-月].[年])
, NULL
, ([Measures].[销售数量] / (ParallelPeriod([时间].[年-月].CurrentMember.Parent.LEVEL, 1, [时间].[年-月].CurrentMember), [Measures].[销售数量]) - 1)
)
环比计算:
Iif (
IsEmpty(([时间].[年-月].CurrentMember.PrevMember, [Measures].[销售数量]))
OR IsEmpty([Measures].[销售数量])
OR ([时间].[年-月].CurrentMember.PrevMember, [Measures].[销售数量]) = 0
OR [Measures].[销售数量] = 0
, NULL
, ([Measures].[销售数量] / ([时间].[年-月].CurrentMember.PrevMember, [Measures].[销售数量]) - 1)
)
Iif (
IsEmpty((ParallelPeriod([时间].[年-月].CurrentMember.Parent.LEVEL, 1, [时间].[年-月].CurrentMember), [Measures].[销售数量]))
OR IsEmpty([Measures].[销售数量])
OR (ParallelPeriod([时间].[年-月].[年], 1, [时间].[年-月].CurrentMember), [Measures].[销售数量]) = 0
OR [Measures].[销售数量] = 0
OR ([时间].[年-月].CurrentMember.LEVEL IS [时间].[年-月].[年])
, NULL
, ([Measures].[销售数量] / (ParallelPeriod([时间].[年-月].CurrentMember.Parent.LEVEL, 1, [时间].[年-月].CurrentMember), [Measures].[销售数量]) - 1)
)
环比计算:
Iif (
IsEmpty(([时间].[年-月].CurrentMember.PrevMember, [Measures].[销售数量]))
OR IsEmpty([Measures].[销售数量])
OR ([时间].[年-月].CurrentMember.PrevMember, [Measures].[销售数量]) = 0
OR [Measures].[销售数量] = 0
, NULL
, ([Measures].[销售数量] / ([时间].[年-月].CurrentMember.PrevMember, [Measures].[销售数量]) - 1)
)