Dear all,
I need to take the average of sums of different months:
Sum 1:
(Sum({<[Year Month]={'$(Current_Month_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Current_Month_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
Sum 2:
(Sum({<[Year Month]={'$(Prior_Month_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Prior_Month_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
Sum 3:
(Sum({<[Year Month]={'$(Prior_Quarter_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Prior_Quarter_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
Sum 4:
(Sum({<[Year Month]={'$(Prior_Year_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Prior_Year_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
I tried:
Avg(
(Sum({<[Year Month]={'$(Current_Month_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Current_Month_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
+
(Sum({<[Year Month]={'$(Prior_Month_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Prior_Month_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
+
(Sum({<[Year Month]={'$(Prior_Quarter_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Prior_Quarter_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD]))
+
(Sum({<[Year Month]={'$(Prior_Year_YYYYMM)'}>}[Cash Amt USD])
/
Sum({<[Year Month]={'$(Prior_Year_YYYYMM)'},[Type Code]={'INV'}>}total <[Year Month]>[Amt USD])))
And this resulted in an error.
Please help me.
Ugur
