1 Reply Latest reply on Jan 9, 2018 1:41 AM by Norbert Maijoor

    Tie refunds back to original order date

    Alex Martino

      I have a folder of transactions.

       

      The first column is "type" and it can be "order" or "refund". Then there is a date column.

       

      Their is a column id with "order id". A refund will have the same order ID as the associated order but a later date.

       

      I want to count refunds but tie them back to the date of the original transaction. So. want to create a new column of dates with all orders having same order date but refunds adjusted to date back to original order.

       

      Can I do this?