1 Reply Latest reply: May 15, 2014 9:54 AM by Nick Osdale-Popa RSS

    NULL AS 0 (ZEROS)

    tnatividad _

      I JUST CREATED A MODEL WITH SOME FIELDS THAT ARE NULL, BUT I WANT TO SHOW 0 (ZEROS). I WENT TO OPTIONS, VIEW AND THEN I SAID SHOW NULL VALUES AS '0'.  HOWEVER WHEN I IMPORTED THE TABLE AS DBF FILE, IT WAS STILL SHOWING BLANKS (NULL). HOW DO I CORRECT THIS.

       

      THANKS....TONY N

        • NULL AS 0 (ZEROS)
          Nick Osdale-Popa

          You'll need to use a calculated field as such:

          [font="courier"]IF(IsNull(), 0,[FIELDNAME])[/font][/quote]where FIELDNAME is the name of your field you want to evaluate.

           

          [size="1"][ December 11, 2002, 02:43 PM: Message edited by: Nick Osdale-Popa ][/size]