Compare two column values and create a new column

snehal1405 — Sat, 16 Nov 2024 21:15:13 GMT

Hi Everyone,

I'm trying to compare values from 2 columns and mark the comparison in a new column with up and down arrow indicators as shown in the picture attached.

I applied if() condition logic:

if(Column(1) = 'NA' or Column(2) = 'NA', 0,
if(Column(1) > Column(2), 1,
if(Column(2) > Column(1), -1)))

The output is attached in the image.

I'm trying to implement a range condition of difference within + or - 5% between column 1 and column 2 values instead of "=NA" for getting the 0 value.

Please Let me know your thoughts.

Thanks in advance,

Snehal

topic Compare two column values and create a new column in App Development

Compare two column values and create a new column