I ran into an issue with the weighted average function.
Suppose you have the following fields:
Sales expected growth
50 - 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?