Hi All,
to me this is really complex. the formula is not returning error but seems not to be giving me what i need .
COUNT(SELECT(WO Record[WO Number],IN([WO Number],{LOOKUP(MAX(WO Record[_ROWNUMBER]),“WO Record”,"_ROWNUMBER",“WO Number”}))))>1)
i would like to see if the latest entry in “WO Number” column has duplicate. i am using this in a workflow.
can somebody please assist if this formula is giving me what i need.
the test result comes a bunch of duplicate but still not running my workflow properly.
much thanks
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |