MDX同比环比的计算

我不是女神ヾ 2022-06-12 12:07 570阅读 0赞

同比：

Iif(IsEmpty((\[table\_profit\].\[报告期\].CurrentMember.Parent.PrevMember, \[Measures\].\[净利率(%)\])) OR IsEmpty(\[Measures\].\[净利率(%)\]) OR (\[table\_profit\].\[报告期\].CurrentMember.Parent.PrevMember, \[Measures\].\[净利率(%)\]) = 0OR \[Measures\].\[净利率(%)\] = 0, NULL, (\[Measures\].\[净利率(%)\] - ( \[Measures\].\[净利率(%)\] ,  Cousin(\[table\_profit\].\[报告期\].CurrentMember, \[table\_profit\].\[报告期\].CurrentMember.Parent.PrevMember))  )  / IIF( (\[Measures\].\[净利率(%)\] ,  Cousin(\[table\_profit\].\[报告期\].CurrentMember, \[table\_profit\].\[报告期\].CurrentMember.Parent.PrevMember)  ) < 0,-( \[Measures\].\[净利率(%)\] ,  Cousin(\[table\_profit\].\[报告期\].CurrentMember, \[table\_profit\].\[报告期\].CurrentMember.Parent.PrevMember)  ),( \[Measures\].\[净利率(%)\] ,  Cousin(\[table\_profit\].\[报告期\].CurrentMember, \[table\_profit\].\[报告期\].CurrentMember.Parent.PrevMember))  ))  
  
  
环比：  
Iif (IsEmpty((\[table\_profit\].\[报告期\].CurrentMember.PrevMember, \[Measures\].\[净利率(%)\])) OR IsEmpty(\[Measures\].\[净利率(%)\]) OR (\[table\_profit\].\[报告期\].CurrentMember.PrevMember, \[Measures\].\[净利率(%)\]) = 0OR \[Measures\].\[净利率(%)\] = 0, NULL, (\[Measures\].\[净利率(%)\] - (\[table\_profit\].\[报告期\].CurrentMember.PrevMember, \[Measures\].\[净利率(%)\])) / IIF((\[table\_profit\].\[报告期\].CurrentMember.PrevMember, \[Measures\].\[净利率(%)\])<0, -(\[table\_profit\].\[报告期\].CurrentMember.PrevMember, \[Measures\].\[净利率(%)\]), (\[table\_profit\].\[报告期\].CurrentMember.PrevMember, \[Measures\].\[净利率(%)\])))

考虑了净利润率的当前值和前值可能有负的情况