Subtracting Rows?

[guerrst]

Hi Community,

I have two reports Report 1 and Report 2 both with Vstring data and numeric 32int data. I need some help with a formula. Essentially what I would like to do is compare (  get the difference) from the cell values of rows 4&5 from report 1 to cell values in row 9&10 (which come from report 2). I've attached a sample report below.

I've been stuck on this for a few days.. any help is greatly appreciated !!!

[Thableaus]

Hi @guerrst 

When you share a workflow with external datasets, you need to export it to a .yxzp format, so we can see the files attached to it.

It seems to me that you're looking for a Multi-Row Formula solution.

Could you please share your data with us?

Cheers,

[guerrst]

Hey @Thableus,

Thanks for letting me know I have attached the .yxzp format. let me know if you can open it!

[Thableaus · Accepted solution]

Hi @guerrst 

Solution attached. Change the inputs of the Workflow to see the results.

Cheers,

[guerrst]

Wow, thank you so much!! this is exactly what I was looking for, you rock!!