Compare Values in Alteryx

Hello All,

I have to compare the values and using the result in Table tool for conditional formatting.

scenario - I have two columns as below

Col1 Col 2

A 100

B 60

C 40

Now I want to compare if the value of A = value of B + value of C the 1 else 0. How to write a formula for this.

Thanks in Advance

Accepted answers

Here is one approach. You can change the else output to null() if you only want the A row to have the test column populated.

Here is one approach. You can change the else output to null() if you only want the A row to have the test column populated.

It works, thanks for the solution.