topic How to Rank based on 2 columns sum in App Development

How to Rank based on 2 columns sum

Karthick30 — Thu, 16 Mar 2023 06:43:22 GMT

Hi,

Please see my sample data set. I need the Rank column based on Days Present + Leave

Example. ID 9823 present days is 12 and Leave is 8. So sum is 20. Rank is 1. Like wise for all users.

Finally I need to show Bottom 2 Ranks in my table. Any way to achieve this

salonicdk28 — Thu, 16 Mar 2023 08:54:20 GMT

Hi,

You can sum both the columns in the script like-

(DaysPresent+Leave) as TotalDays and then use this in table's expression-

= Aggr(Rank(Sum(TotalDays)), ID)

I am getting the below result, hopefully this is what you are looking for-

Thanks,

Saloni

MayilVahanan — Thu, 16 Mar 2023 09:05:16 GMT

Try like below

Dim: ID

Exp: If(Rank(-Sum([Days Present]+Leave)) <=2, Sum([Days Present]+Leave))

-- it will display bottom 2 info

Karthick30 — Thu, 16 Mar 2023 19:13:00 GMT

I have some Identical values. So when i put Rank < 10 , I am getting only 9 values.. Because 2 values showing rank 6

Any way to fix this Please