Compare two columns over a threshold

Hi,

I have a workflow that outputs a table as shown and attached. I would like to compare "O Count" vs "L Count" and add the 'Desired Result' column showing '1' if either column has a value of >= 30 and the other column = 0. Thanks for any help on this.

CountCompare.xlsx

Workflow

Developer

Preparation

Data Investigation

Accepted answers

BonusCup

Hi @JosephSerpis. I was able to resolve the issue I was having with an IF, ELSEIF statement. Thanks for putting me on the right path.

IF [O Count] >= 30 and [L Count] = 0 then 1
ELSEIF [L Count] >= 30 and [O Count] = 0 then 1
ELSE 0
ENDIF

All comments

JosephSerpis

Hi @BonusCup I mocked up a workflow it matches your output apart for row 9 where L count is 23 and 0 count is 0. Let me know what you think?

Compare_Columns_141119.yxzp

BonusCup

Thanks @JosephSerpis. Row 9 is where I'm having an issue too. The "0" value could appear in either column sometimes so I needed to call that out but only if the other column is over 30.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317