Calculation average

[Anonymous]

Hello,

I want to calculate the average of each product taking an account the number of periods that differs from a product to another.

you can notice in the attachment that for the product "ADVANCE" there is only five periods available so the average will be the sum of Actual Sales divided by 5 and for the product ANATEO i have to devide the sum of actual sales   by 15 because we have 15 periods.

How can I do that?

Thank you,

Alâa Eddine

[ogautier62]

Hi,

if you use avg(Sales) as expression you'll have the correct result for subtotal Product

regards

[Anonymous]

Hello,

thank you for your answer.

I tried that but it does not work correctly.

I show you what i have:

For the product "ADAVNCE", for example if we do the sum we will find 9 products in total on 5 periods so the average will be 9/5.

This is what i want to calculate.

[dapostolopoylos]

Can you provide a sample document so we can play around with it,in order to find a solution?

[sasikanth]

Try below exp,

Sum(ActualSales)/Count(Year Month)

[Anonymous]

Hello,

i tried but the calculation was incorrect.

Any other ideas, please?