3 Replies Latest reply: Dec 18, 2014 9:47 AM by Emilien Petrini RSS

    Alternative to GetPossibleCount()

    Emilien Petrini

      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!

       

      QVIEW.png