2 Replies Latest reply on Mar 18, 2014 12:32 PM by EgbertRoos

    Weighted average

    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