Forecast sales values computation using average sales price (set analysis)

[agaetisproject]

Hi all,

I am trying to compute a sales amount forecast based on the number of units forecast and the average sales price of a unit.

I struggle with a set analysis statement that is intended to calculate the average sales price of each unit and for each country.

Below is my table:

Th expression for the average price is (intended to get the average price per unit, regardless of the year).

avg({$<Year = {*}>} Value/Unit sold)

My issue is that the yellow cells stick to 0 in my table whereas I would like see in there the average price based on years where there was sales.

Can anyone help me get this statement correct?

Thanks!

[MK_QSL]

Last Country is A? How you get 30 Average Price for it?

[agaetisproject]

nope Manish, last country is B, sorry for the typo.

[MK_QSL]

You can get average price as below

SUM(TOTAL <Country> Value)/SUM(TOTAL <Country> [Unit sold])

now multiply it with your Forecast Units to get the Forecast Value