Compare Values in Alteryx

[sharduldolas1]

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

[wwatson · Accepted solution]

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.

[sharduldolas1]

It works, thanks for the solution.  

[sharduldolas1]

In Addition to the earlier scenario.

How to compare values of different rows.

Scenario

Col1         Col2

A               10

B                0

C               5

D              7

E              10

I have to compare the values of A and E, how to do it

Thanks in Advance.