Multiple column calculation ( two table)

Question

Dear Community,

I faced some challenge in doing the calculation which involving two table and  would like to ask if anyone know how to convert the steps below to the alteryx workflow:

Many thanks in advance and appreciate if someone can share the workflow based on the sample data (attached below)

Two table and multiple column calculation.xlsx

AngelosPachis · Answer

Any updates on this @SH_94  ?

AngelosPachis · Answer

Here's a workflow to get you started @SH_94 . It answers questions in Step 1 and Step 3

Hope that's what you were after, let me know if there's another way I can help.

Cheers,

Angelos

sample_workflow.yxmd

SH_94 · Answer

Hi @AngelosPachis ,

I actually stuck in the step 1 and 3 because it is related and i not sure how to make the step 1 so that the arrangement fit the step 3.

Thank you.