Apply Formula in Alteryx

[Inactive User]

Team,

Kindly review the attachment, the formula is applied on column W, column X and column Y. I would like to know if there is any logic in Alteryx to perform these formulas. Thanks in advance for reviewing this item.

Thanks,

Guru

[Inactive User]

Team,

Kindly review the attachment, the formula is applied on column W, column X and column Y. I would like to know if there is any logic in Alteryx to perform these formulas. Thanks in advance for reviewing this item.

Thanks,

Guru

[Luke_C · Accepted solution]

Hi @Inactive User 

Here's my solution to this - it can be accomplished with if statements, joins, and summarize tools. These recreate your vlookups, sumifs and conditional formulas.

[Inactive User]

Thanks @Luke_C