Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
here is my question:
Level | Bck | Outstanding | Cumulative |
Buckets | 0 | 377,584,853 | 0.00% |
Buckets | 1 | 25,220,876 | 9.20% |
Buckets | 2 | 5,825,238 | 3.33% |
Buckets | 3 | 2,469,277 | 1.97% |
Buckets | 4 | 992,782 | 1.39% |
Buckets | 5 | 1,088,848 | 1.16% |
Buckets | 6 | 723,701 | 0.91% |
Buckets | 7 | 840,574 | 0.74% |
Buckets | 8 | 500,289 | 0.54% |
Buckets | 9 | 402,360 | 0.43% |
Buckets | 10 | 544,369 | 0.33% |
Buckets | 11 | 642,705 | 0.21% |
Buckets | 12 | 248,420 | 0.06% |
Buckets | 13+ | 9,950 | 0.00% |
Buckets | Total | 417,094,244 | 97.14% |
Write Off | 13+ | 12,296,755 | 2.86% |
Write Off | Total | 12,296,755 | 2.86% |
Total | 429,390,998 | 100.00% | |
this is how i calculated my cumulative field :
if(Aging_Bucket=0, 0, RangeSum(below( TOTAL Sum (Outstanding),0,20))/sum(TOTAL Outstanding))
but the problem is that i need the total Outstanding is including the Write off but my request is the sum (TOTAL Outstanding) should be equal to
417,094,244 not 429,390,998. (417,094,244 is the total number of bck)
And about the write Off cumulative should be calculated as (Outstanding of wirte OFF)/429,390,998
Please help Thank you .
Perhaps
Sum({<Level={'Buckets'}>} TOTAL Outstanding)