3 Replies Latest reply on Feb 21, 2019 3:17 AM by Alex Martino

    refund back to original date

    Alex Martino

      Hello. I have the following.


      Transaction #, Date, Category, Quantity, Type.


      I want to calculate refund rate % by category TYING BACK TO THE ORIGINAL MONTH OF THE TRANSACTION. For example, in this case, the refund tied to the transaction occurs in the second month. The refund % for shirts in January should be 50% and 0% for February. Screen Shot 2019-02-13 at 10.06.55 PM.png