Hello i have a table like the below. I want a rank column which will show me the rank based on the price. how can i do this? Order NoProductPriceRank (Price)123Bread31123Eggs23123Eggs2.52123Beans14

Yes it can ! Here is the updated workflow !

All comments

Hi @Sammy22 ,

You can do it by using Sort tool then RecordID tool ! Here is a sample workflow !

Hi @Sammy22

You can do something like below. This method will help you if you want to maintain data row order.

Workflow:

1. Using record id tool to capture order.

2. Using sort tool to sort descending on price.

3. Using record id to set rank.

4. Using sort tool to sort back into order.

Hope this helps : )

Rank.yxmd

Sammy22

There are multiple order numbers so i need the ranking grouped by the order number. Sorry should have clarified in the first message!

Here is the updated version !

Hi @Sammy22

You can use multi-row formula tool to create group ranking.

Workflow:

Hope this helps : )

Rank.yxmd

Sammy22

Can it give the same rank if the price is the same. it wouldn't currently do that it seems.

Order No	Product	Price	Rank
123	Bread	3	1
123	Eggs	2	2
123	Eggs	2	2
123	Beans	1	4
456	Eggs	3	1
456	Eggs	2	2
456	Beans	1	3

Hi @Sammy22

It should work. Refer snapshot below.

Hope this helps : )

Rank.yxmd

Yes it can ! Here is the updated workflow !