4 Replies Latest reply on Oct 21, 2018 8:47 PM by Mahfooj Khan

    average at order level

    Alex Martino

      Hello. I have orders in rows. The same order can have multiple rows.

       

      I created a cross tab that shows quantity per order, and cost of fees per order. When I create a formula that divides cost per order/quantity per order it doesn't give me the correct average?

       

      ([Quantity])/([REAL REAL FIXED FEE])Screen Shot 2018-10-20 at 1.54.06 AM.png