1 Reply Latest reply on Feb 13, 2019 10:58 PM by Aniruddha Dhamne

    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