Subtracting a specific row from another

[Tala]

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)

[Raj]

Are you looking for something like this.

[Tala]

The multi row formula tool isn't really working with me on the actual dataset plus, i still need the output to be connected to all of the other data

[grazitti_sapna]

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

[Tala]

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]

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