Can I create a workflow in Alteryx to mimic this Excel file showing delta's

[MikeFrancis1959]

I have an Excel file that shows the purchase orders by week vs the sales orders and my manager asked that I create in the format attached in Alteryx. I have 2 files that I will use, one for purchase orders and one for sales orders. The part of the workflow I am not sure about is that the PO qty is on row 1, the SO on line 2 and the delta between the two is on row 3 and this is where I am not sure how to start the formula. I thought about multi row formula but I dont this this will produce the results I want, can someone point me in the right direction?

Thanks,

Mike

[FrederikE · Accepted solution]

Hey @MikeFrancis1959, 

I guess SO and PO Data is provided and you want to calculate the Delta everywhere? 

You could do the following:

Muli-Row is not so great because you would need to combine a Multirow and Multicolumn approach. 

[MikeFrancis1959]

I followed the logic and this works perfectly!

Thanks,

Mike