Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thanks,
Bharat
Check now
So the calculation for 0 to 1 is completely difference from rest of them? Or is the only difference is that except 0 to 1, you want to look at Aging for that period and the previous period?
Hi Sunny,
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.
Thanks,
Bharat
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?
hi Sunny,
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
So, basically you want this
4559 - 379.92 - 468.83 - 22.84 + 0 = 3,687.41?
Check attached
Hi Sunny,
Slight correction in your formula i.e.
4559 - 379.92 +468.83 - 22.84 + 0 = 4625.07
Check now