1 Reply Latest reply on Oct 21, 2018 12:05 AM by Mahfooj Khan

    fixed formula for average not working

    Alex Martino

      I have order ID's down a column. Occasionally, there can be multiple order ID's on separate rows.


      I want to get an average cost of a fee at the order ID level.


      I used this formula:


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


      The problem occurs when there are more than 1 order ID row in the data set.


      For example


      ID 1, quantity 1, fee -3.19

      ID 1, quantiy 1, fee -3.19


      My formula calculates an average that is half of what it is supposed to be.


      Also another question is if I have a filter on the sheet, will the fixed formula ignore that filter? Because I want to ignore a specific type of order but it doesn't seem like it's doing that.