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
You could tackle this a few different ways. I usually use an if statement to do a test of the field.
If([3 Month Average Build Cost] >1, ([3 Month Average Build Cost] * 10) ,0)....
or add variables at the top to handle it before it hits the main formula.
var number ThreeMos = if([3 Month Average Build Cost]>1,[3 Month Average Build Cost],0)
$ThreeMos *10
------------------------------
Tammie King
------------------------------
If([3 Month Average Build Cost] >1, ([3 Month Average Build Cost] * 10) ,0)....
or add variables at the top to handle it before it hits the main formula.
var number ThreeMos = if([3 Month Average Build Cost]>1,[3 Month Average Build Cost],0)
$ThreeMos *10
------------------------------
Tammie King
------------------------------
