Division of two rows; get diff in %

Hello,

I want to compare the prices of all my toys with dragons. Dragon is the first row while two toys are below. They are in yellow below.

The result should be a separate column (marked in blue), price difference shown in percentage.

Basically, I want to see how cheaper other toys are because the dragons are the most expensive in my store.

Can you please help how this in Alteryx as it is plain easy in Excel?

Thanks

Datasets

Common Use Cases

Best Practices

Accepted answers

Tyro_abc

Hi @LuneLune

This is my workflow, I took the first row separately and then joined with the original file. So, first row can be anything and you can still compare with first row toy.

Dragon Toy.yxmd

All comments

clmc9601

Hi @LuneLune,

Here is a workflow that calculates the percent difference. I hope it helps!

Compare Toy Prices.yxmd

Tyro_abc

Hi @LuneLune

This is my workflow, I took the first row separately and then joined with the original file. So, first row can be anything and you can still compare with first row toy.

Dragon Toy.yxmd

pedrodrfaria

Hi @LuneLune

Please see attached the workflow below:

For educational purpose, I created two different workflows to accomplish this task. One that is based on which product you want to compare using the name. And the second one is based on the order of the list.

Please assign the solution(s) to the discussion post. This helps us all.

Pedro.

Workflow Prices.yxmd

LuneLune

Thank you all for help, it works perfectly.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280