Help With Formula 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
MarkShnier__You
Qrew Legend
Qrew Legendtry this
var number NumberOfMonths =
IF(not IsNull([3 Month Average Build Cost]),10,0)
+
IF(not IsNull([6 Month Average Build Cost]),6,0)
+
IF(not IsNull([1 Year Average Build Cost]),3,0)
+
IF(not IsNull([2 Year Average Build Cost]),1,0);
( nz([3 Month Average Build Cost]) * 10
+ nz([6 Month Average Build Cost]) * 6
+ nz([1 Year Average Build Cost]) * 3)
+ nz([2 Year Average Build Cost])) / $NumberOfMonths
// the nz function will turn a null into a zero
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var number NumberOfMonths =
IF(not IsNull([3 Month Average Build Cost]),10,0)
+
IF(not IsNull([6 Month Average Build Cost]),6,0)
+
IF(not IsNull([1 Year Average Build Cost]),3,0)
+
IF(not IsNull([2 Year Average Build Cost]),1,0);
( nz([3 Month Average Build Cost]) * 10
+ nz([6 Month Average Build Cost]) * 6
+ nz([1 Year Average Build Cost]) * 3)
+ nz([2 Year Average Build Cost])) / $NumberOfMonths
// the nz function will turn a null into a zero
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Thanks Mark! I had to play around with some add'l parenthesis but the formula it worked like a charm!
As far as the double post...that's weird! I looked for a way to delete the duplicate but couldn't find a way.
------------------------------
Josh Collins
------------------------------
