I am creating a financial Report which i am having problems with
Metric 1 Metric 2 Metric 3 Metric4
1 A
2 B
3 A-B
4 (A-B)+C
5 ((A-B)+C)-D
6 ((A-B)+C)-D)+E
A, B, C, D, E is attributes.
Metric 3= % of (metric1-metric2)/metric2 for row 1, 3, 5
And for other rows % of (metric2-metric1)/metric2
For the metric 3 I am using a Calculation:
Sum (Apply Simple ("Case When #0 in (A, A-B, ((A-B) +C)-D) Then #1 Else #2 End", Parent, (metric1-metric2)/metric2, (metric2-metric1)/metric2))) {~+}
When drilling down from A Attribute to the child level the calculations are not coming properly.
Metric 1 Metric 2 Metric 3 Metric4
1 A
2 B
3 A-B
4 (A-B)+C
5 ((A-B)+C)-D
6 ((A-B)+C)-D)+E
A, B, C, D, E is attributes.
Metric 3= % of (metric1-metric2)/metric2 for row 1, 3, 5
And for other rows % of (metric2-metric1)/metric2
For the metric 3 I am using a Calculation:
Sum (Apply Simple ("Case When #0 in (A, A-B, ((A-B) +C)-D) Then #1 Else #2 End", Parent, (metric1-metric2)/metric2, (metric2-metric1)/metric2))) {~+}
When drilling down from A Attribute to the child level the calculations are not coming properly.