Rank Function

J Tech

Hi,

How do I create a rank formula for the field, that only includes certain values from a row that meets certain criteria.

For example the below image is the example. I only want to rank and include in the range active expenses. Can someone please help me.

MCorbin

In order for it to work, I had to create a helper column that removed the Expense if the Status wasn't Active (mine isn't formatted as $, but it can be)

"Value Expense" =IF(STatus@row = "Active", [Total Expense]@row, "")

Then I created the Ranking column looking at the Value Expense Column:

=IF(STatus@row = "Active", RANKEQ([Value Expense]@row, [Value Expense]:[Value Expense]), "")

If I didn't eliminate the "Obsolete" value, it was included in the ranking, even if it didn't show in the column (see the numbers in the Expense Rank column)

MCorbin

In order for it to work, I had to create a helper column that removed the Expense if the Status wasn't Active (mine isn't formatted as $, but it can be)

"Value Expense" =IF(STatus@row = "Active", [Total Expense]@row, "")

Then I created the Ranking column looking at the Value Expense Column:

=IF(STatus@row = "Active", RANKEQ([Value Expense]@row, [Value Expense]:[Value Expense]), "")

If I didn't eliminate the "Obsolete" value, it was included in the ranking, even if it didn't show in the column (see the numbers in the Expense Rank column)