It's the ZERO setting. With ZERO on, NULL is evaluated as zero. If you set ZERO off, it leaves it a NULL. I'd be wary of doing that though. You may get NULLs where you really want ZEROs in other equations.
Try this at the R> with ZERO ON, then again with ZERO OFF: SET VAR vquantity INTEGER = 0 SET VAR vtest = (IFNULL(.vquantity,.vquantity,(.vquantity / 12))) With ZERO ON, vtest will be 0.; with ZERO OFF vtest will be NULL. Like I said, I would be wary of changing the ZERO setting without testing other equations. Can't you set the display format of the variable on the report to "blank when zero"? Dawn Hast [email protected] wrote on 10/28/2009 11:28:19 PM: > I'm having trouble getting a report variable to be NULL. > I want 3 report fields to be blank if there is a NULL value. The > first field comes > from the table, the others are calculated from the first. The first > field comes out > blank with a NULL from the table. The NULL format is blank for all > the fields. > > I tried to set a test variable = first field variable (that is NULL) > but the test > variable's field came out 0. > > Here's a logic function that I'm trying to use: > (IFNULL(vQuantity,vQuantity,vQuantity/12)) > I've tried several values for arg2 without being able to obtain a > NULL result. > 1 gives 1 ; this proves that the logic works and the problem is to > get a null result > '' gives 0 > ' ' or (CVAL('NULL')) gives an error, 1st & last 2 args of IFNULL > must be the > same type > NULL and 'NULL' give 0. > ,, or , , give error: a comma cannot follow a comma. > > Geoffrey in Thailand > > DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
