Help with calculating difference between two rows

[Taxguy03]

Hello Alteryx expert, 

I have a fairly simple problem but can't figure out what tools to use. We're trying to calculate the variance between two rows for two years. I have attached the file in excel and the anticipated result. I really hope someone can help. 

Thanks in advance. 

[vizAlter · Accepted solution]

Hi @Taxguy03 — Try this solution:

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

[DannyS · Accepted solution]

hi @Taxguy03 ,

This is another solution as well.

[Taxguy03]

Thank you both for your quick help. I'm so grateful for the community. Please take care. 

[vizAlter]

@Taxguy03, @DannyS — Thank you!

[Taxguy03]

Thank you for your quick turn around. The solution works and easy to follow. Community to my rescue again.