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

how to get the product Average selling price monthly with FMP

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

• 1. Re: how to get the product Average selling price monthly with FMP

On paper, how would you compute that average from the data in your table? Should the second row of your report show an average of 12.36? (61.8 divided by 5)

How do you compute the monthly totals?

Does each row of number represent one record or a group of records?

• 2. Re: how to get the product Average selling price monthly with FMP

actually.

we have the every  sales row  by date

then I have some calculate field. to get some middle level data.

please see the attached graph.

• 3. Re: how to get the product Average selling price monthly with FMP

If I read that last info correctly, each row of numbers represents a group of records and you are using a sub summary part "when sorted by ShipMonth" to produce the values shown.

To repeat a question: On paper, how would you compute that average from the data in your table? Should the second row of your report show an average of 12.36? (61.8 divided by 5)

I need to know if that's the average you need to compute here.

• 4. Re: how to get the product Average selling price monthly with FMP

Hi, Phil

To repeat a question: On paper, how would you compute that average from the data in your table? Should the second row of your report show an average of 12.36? (61.8 divided by 5)

Yes, you are right. I need the 61.8/5 =12.36 show .

now, I have another solution to fix the issue. I use the

Product_ASP is calculated filed.

Let ([

productqty= GetSummary ( POS Qty. Total ;Shipmonth );
productSO=GetSummary ( POS Amnt. _USD_ Total;Shipmonth)
];

productSO/productqty
)

it is okay to work. but , I did not know if you have better solution.

thank you

Wisdom

• 5. Re: how to get the product Average selling price monthly with FMP

I think I'd be using the same calculation you have. GetSummary is intended to access subtotals exactly like you are using it here.