Subtracting a specific row from another

Question

Hello. I have a dataset that includes a "Type" column which contains the fiscal years and another column that's called "Hours". I want the difference in the hours worked each year and I want it to be DYNAMIC and I would prefer it if the output is in another column.

Type       Hours

FY22       10

FY23       15

FY22       5.7

FY20         8

FY21        13

FY20        7.8

I want the (Hours worked in FY22 - Hours worked in FY23)

grazitti_sapna · Answer

Hi @Tala 
Attached workflow contains difference of hours in different columns. Kindly Check if it works for you 
Thanks

Difference in hours.yxzp

Tala · Answer

Hi Grazitti,

Thank you but I already tried that and it did not work because I want the difference in hours between each one of the years (FY22-FY23, FY21-FY22, ..etc.) and I want it to still be connected to my dataset.

grazitti_sapna · Answer

Hi @Tala 
I have made workflow for difference in hours in column. Hope it works for you. 
Thanks

Difference in hours.yxzp