Filter Condition

Question

Hi Friends,

I have a query. I have data under two columns, now I need to select one but the condition is, I have to find which column have more data between both the columns and system should move forward according to it.

As per the attached data, where the Active numbers are more, basis on column B & C.

ACTIVE.xlsx

ArijitRoy · Answer

Hi DevidP,

According to your workflow, under Status we have 650 Active lines and under Line Status we have 614 Active lines. Now I want system should pick the data accordingly which have higher Active lines. Now over here we have Status have 650 Active lines. How can I do that?

ArijitRoy · Answer

Hi @DevidP

Column B & C have Active and Signed but we have to look for the count of Active numbers first. B have more Active counts or C. I want system first find and then automatically select the column and move forward for next step.

DavidP · Answer

Hi @ArijitRoy

I'm not sure I understand exactly what you're looking for. It is something like this?

compare Active Status by instance number.yxmd