Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Last Country is A? How you get 30 Average Price for it?
nope Manish, last country is B, sorry for the typo.
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