2 Replies Latest reply: Jan 6, 2012 8:16 AM by Cesar Accardi RSS

    Summing a field when there's a null value in one of the records

      Is there a setting I can change to treat nulls as a zero in calculations found in my scripts?

       

      I've used           if(isnull(field1)=0,field1,0)

       

      However it tends to make my script run longer.

       

      I've just seen Alt(field1,0) method and plan on testing it out.

       

      Are there any other ways to have the script interpret a field as zero with minimal impact to load times?

      I'd prefer to simply used a SET statement and have QV simply interpret nulls as zeros however I haven't seen anything like this.