Rangesum with Aggr?

[prasadcm]

Hi ,

I have straight with expressions as Amount =Sum(Amount),Balance=RangeSum(above(total(sum(Amount)),0,rowno(Total)))

Balance is total of Amount

Now when i search for bank name eg: Bank Indosuez singapore

its amount is 102000 & balance is 102000 which is correct

But when i dont make any selections and view the table I get

Above bank Balance gets added

I want the balance to be grouped by bank name

I tried with aggr(RangeSum(above(total(sum(Amount)),0,rowno(Total))),[Bank Name]) bt didn't get desired output...

stalwar1‌

[prasadcm]

No,How am i supposed to do that?

[sunny_talwar]

I will take a look at the attached sample you have posted on the other thread and give you suggestion

[prasadcm]

Hi stalwar1‌

Solution suggested by you works,but i am getting duplicate records for it.

Regards,

Prasad

[sunny_talwar]

Did it? I am still not fully sure what the expected output here is? Would be able to elaborate where you see the issue. May be take snapshots and circle the issue for us?

Thanks,

Sunny

[prasadcm]

Hi stalwar1‌,