Multi-Row Formula Not Generating the Expected Output

hi, i would like to compare row-1 and row-2 for a specific field in my workflow. my configuration should give me a "yes" or "no" but i am not getting the correct output for some of my data. i've cleaned up my data so there are no unwanted characters. please see details below.

expression: IF IsEmpty([Value]) and [Row-2:Value]=[Row-1:Value] THEN "TRUE" ELSEIF IsEmpty([Value]) and

[Row-2:Value]!=[Row-1:Value] Then "FALSE" Else [Value] ENDIF

appreciate all your help.

thank you.

multi-row error.PNG

Workflow

Common Use Cases

Best Practices

Accepted answers

atcodedog05

Hi @crazybeauti_ful

The possibility is it is checking it as date and hence matching. Can you please provide sample data in excel file we can take a look on developing a workflow.

Happy to help : )

atcodedog05

Hi @crazybeauti_ful

Try this i guess you are trying to reference row+1 and row+2 but referencing row-1 and row-2.

Hope this helps : )

yes.yxmd

All comments

atcodedog05

Hi @crazybeauti_ful

The possibility is it is checking it as date and hence matching. Can you please provide sample data in excel file we can take a look on developing a workflow.

Happy to help : )

crazybeauti_ful

hi @atcodedog05 , i've attached a sample data. note that the field's data type is v_wstring. the highlighted cells are the actual output of my multi-row formula; the red ones are wrong.

appreciate your help.

sample.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703