Forum Discussion

AsishMathew1's avatar
Qrew Trainee
4 years ago

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...
  • MarkShnier__You's avatar
    4 years ago
    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