AnsweredAssumed Answered

how to get the product Average selling price monthly with FMP

Question asked by wisdomz on Mar 30, 2012
Latest reply on Apr 4, 2012 by philmodjunk

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

Outcomes