I have a chart. In that i have a dimension called cat and some expressions. Below image for reference:
In the IB end the value for 0 to 1 year is correct.
But from the second one i.e. b)1 to 2 year i need to calculate 4559+379.92+468.83-22.84+0.. I want to how can we sum 379.92+468.83.
The same for C)2 to 3 year i need to calculate 3874+322.83+379.92.83-22.07+0.
The same for D)3 to 4 year i need to calculate 3489+290.75+322.83-22.07+0.
Can you please tell me how can we do this.
Attached app for reference.
Please let me know if you require anything more.
yes,the only difference is that except 0 to 1, I want to look at Aging for that period and the previous period..
The calculation for 0 to 1 is fine... rest i need in the above one i explained.. The value for IB End for 0 to 1 is correct..Rest i i need to sum of this aging and previous aging..
Please let me know if you need anything more.
Going by the same logic for 1 to 2 years.... 0 to 1 would be something like this, right
5,626 + 468.83 - 24.71 + 175.56 = 6,245.68... how is 5,507.71 correct? Am I missing something here?
For 0 to 1 it is 5626- 468.83-24.71+ sum(total of cons)..i.e.199.69+175.56
But for rest it is the formula changes to 4559-379.92+468.83-22.84+0
Please let me know if you need anything more