AnsweredAssumed Answered

Weighted average

Question asked by EgbertRoos on Mar 18, 2014
Latest reply on Mar 18, 2014 by EgbertRoos

Title

Weighted average

Post

     Hi all,

     I ran into an issue with the weighted average function.

     Suppose you have the following fields:

     Sales                expected growth

     50                              - 5%

     100                              0%

     200                              5%

      

     FM calculates an weighted average growth rate of 3% (averaged on sales) where the record with 0% growth isn't taken into account. In most cases I guess this makes sense. However I really would like to take the record with 100 sales and 0% growth into the average growth rate, which would make an average of 2.14% on total sales.

      

     Anybody an idea how to solve this one?

      

     Best regards,

     Egbert Roos

Outcomes