同比：
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].[净利率(%)])))
考虑了净利润率的当前值和前值可能有负的情况
版权声明：本文为vah101原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。