1 Reply Latest reply on Oct 20, 2018 11:50 PM by Mahfooj Khan

    Fixed average at order level

    Alex Martino

      Hello. I have orders in a column. There can be duplicate order #'s in the column.

       

      I have a sum of total and then a sum of fees per order.

       

      I want to create the average for each order but it's not computing correctly.

       

      What is wrong with this?

       

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