Solved
not isNull in an if statement
If(
[Activity Type Code] = "4" and [Analysis Status] = "Complete", 120*[Actual Modeling Hours Required],
[Analysis Status]="Complete" and not IsNull([Construction ROM / Scope Estimate]), [Construct...
- uncheck the box on that field that says to treat blanks as zero or else test for zero. Probably better to just test for = 0
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
