Comparing multiple rows with same values

iamRandy

Hi,

I have a set of data where OrderNumber column can have duplicate values and order status for the duplicate order number can have a Cancel or Approve status.  I need to know how to compare the order number value by using a formula to mark the duplicate order number as 1 order number. 

For example, Order #1 on 12/1/2022 with a status of "Approved" then on 12/3/2022 Order #1 was "Cancelled" . I need to assign a status "False" on the Cancelled order.  

Is this possible through formula?

PanPP

Hi @iamRandy 

Would you be able to show a sample output?

You can use a conditional statement described below: If [Status] = "Cancelled" then "False" else [Status] endif

You can then summarize and group by order numbers based on status.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.