4 Replies Latest reply on Mar 29, 2017 5:31 PM by Deepak Rai

    Price per order

    Alex Martino

      I have order transactions. Some of these have "quantity" = 2 or more. I want to return the average price per transaction. So, for order #1, if  product sales = 10 and quantity=1 then transaction is $10 and so on. However, I treid this formula below but it's not working. It still returns total transaction dollars (just product sales).

       

      IF [Type]="Order"

      THEN

      [Product Sales]/[Quantity]

      END