Forum Discussion

AsishMathew1's avatar
AsishMathew1
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
    MarkShnier__You
    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
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------