Multiple column calculation ( two table)

[SH_94]

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)

[AngelosPachis]

Ηι @SH_94 .

In which step of the process did you get stuck? It would help others if you show them where you got to before reaching out for help. Here's a post with some community best practices that I like to follow:

https://community.alteryx.com/t5/Alter-Nation/AYXKCD-Types-of-Alteryx-Community-Posts/ba-p/785218

Kind regards,

Angelos

[SH_94]

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.

[AngelosPachis]

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

[AngelosPachis]

Any updates on this @SH_94  ?