5 Replies Latest reply on Apr 4, 2012 11:31 AM by philmodjunk

    how to get the product Average selling price monthly with FMP

    wisdomz

      Title

      how to get the product Average selling price monthly with FMP

      Post

       Master

      I have the Point of Sales list for total year, the list have the following field.

      customer, product, ship_month, ship_qty, ship_amt,

      I want to run a report , it shows the product average selling price monthly.

      I define the "calculated field" , such as ship_qty total, ship_amt total.  I must get every product Monthly Qty and Monthly ship_amt. but I did not know how to get the ASP, if I use another New field calculate it, (ship_amt total/ship_qty total), it return the result that shows total years sales out/ total years qty.

      Do you have good idea to me. and I want to make a chart with the Average selling price.

      thank you

       

      Wisdom

       

       

      ASP_question.png