Set Analysis Question

mario-sarkis — Thu, 16 Jul 2015 07:26:31 GMT

here is my question:

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 .

Re: Set Analysis Question

antoniotiman — Thu, 16 Jul 2015 07:49:15 GMT

Perhaps

Sum({<Level={'Buckets'}>} TOTAL Outstanding)