Formula Help for Weighted Average Field
Hello, I am trying to fix a formula for a numeric formula field that calculates the weighted average build cost of house plans we build. Here is the formula: (([3 Month Average Build Cost] * 10...
Forum Discussion
For starters, I think you need to have a couple of additional fields, like a divisor-count field, that is tallied based on the number of non-blank summary count fields. (I really hope that makes sense).
Then, the way I think I might do this is write variables in the formula to "hold" values that are not blank, then do the math based on the variables that are valid and using your divisor field.
Hope this helps.
------------------------------
Ryan Buschmeyer
------------------------------
Then, the way I think I might do this is write variables in the formula to "hold" values that are not blank, then do the math based on the variables that are valid and using your divisor field.
Hope this helps.
------------------------------
Ryan Buschmeyer
------------------------------