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])}