UI Sorting on Rangesum(Above(***))

[mohan2391]

Hi 

I have data like below.

I want a new column that needs to be generated only in UI. (We should start with a reference number 30, mentioned in formula below)

New column = 30+total received-total closed(till that week)

This below expression is working as expected and giving correct numbers

But the users want to see this above UI table in screenshot in reverse order. I mean they want to see w8, 2, 1, 30

w7, 4, 3, 29

******

w2, 3, 4, 28

w1, 1, 2, 29

Basically only the sorting should change but numbers should not change.

When I sort it in descending order in Sorting option, the numbers are changing, but it shouldn't happen.

Can you please suggest how to achieve this without changing the new column values. And I need it only in front end not in script.

 

[ckarras22 · Accepted solution]

Hello,

I think you need:

30 + RangeSum(below(total sum(received),0,100000))-RangeSum(below(total sum(closed),0,100000))