1 Reply Latest reply on Oct 29, 2018 5:25 AM by Simon Runc

    Limit quantity in fixed to a specific type

    Alex Martino

      I have this formula below and it works fine in 98% of cases.

       

      However, some orders have type = return, which makes the quantity = 2 so it divides the fixed fee by two. How can I exclude type = "Refund" in this formula? Screen Shot 2018-10-29 at 3.48.05 AM.png

       

      {Fixed [Order Id]:sum([Fixed Fee])/sum([Quantity])}