1 Reply Latest reply on Oct 20, 2018 6:47 AM by Ankit Bansal

    How to exclude in a fixed formula

    Alex Martino

      I'm trying to get an average at an order ID level. I'm not sure if this is the correct formula to use.

       

      {Fixed [Order Id]: sum([REAL REAL FIXED FEE])/sum([Quantity])}

       

      I have a type of order that = either order or refund. I put a filter on type = order to exclude the refunds (which have the same order ID). However it seems like this filter is not working as any order that has a correspond refund has a lower average (because I think it is counting quantity from that refund). How can I fix this?

       

      Also, this formula doesn't calculate correctly when there are multiple rows with the same ID. I thought that was the point of fixed, no?