Alternative to GetPossibleCount()

[Anonymous]

hello,

I have a little problem on a formula for calculating the value of the average quantity delivered my formula : sum(CE11000.Sales_Quantity) / GetPossibleCount (CE11000.Period)

This works very well when my product was delivered during the 6 months selected but here my article is delivery only in March so in the formula the GetPossibleCount = 1 and I wish it all the time equal to my selection here I want GetPossibleCount = 6.

Do you have any idea?

Thank you in advance!

[Aurelien_Martinez]

Hi,

I think this expression can help you :

sum(CE11000.Sales_Quantity) / Count({<CE11000.Period=>} DISTINCT CE11000.Period)

Aurélien

[#3]

Did you try the below

GetPossibleCount(CE11000.Period)+GetAlternativeCount(CE11000.Period)

[Anonymous]

I finally found a solution :

GetSelectedCount(CE11000.Period,1)

Thank you for your answers