Non Null Data showing as null

[#1]

I am getting occasional null data displays in my straight table when the data is not null.

**NOTE:  I have my properties set to "NNUU" being used for the null representation instead of "-"

Please see view below.  To Try and identify I changed my load script to this:

if (IsNull("po_num"),'999','*' & "po_num" & '*') as po_num,

As you can see by the screen print, it is not showing as null, otherwise it would bring in 999 as a value, but yet it brings in my "NNUU" Null identifier.  I have tried the LEN function to see if it was LEN("po_num") = 0 and it again passed that test....but displays the Null value.

This happens very sporadically which leads me to believe this are hidden/invisible characters at work here (which I was hoping to identify with the * symbols added.)

Any thoughts on this fluke?

Let me clarify:  I am not trying to get the 999 statement above to work.  I am trying to figure out why this field is getting the null representation shown "NNUU" when it has a valid and normal PO number in the database.

[#2]

Hi,

try with this:

Text(if (IsNull("po_num"),'999','*' & "po_num" & '*')) as po_num,

or

if (IsNull("po_num"), Text('999'), Text('*' & "po_num" & '*')) as po_num,

Regards,

Ricardo

[#3 · Accepted solution]

You said:

"Let me clarify:  I am not trying to get the 999 statement above to work.  I am trying to figure out why this field is getting the null representation shown "NNUU" when it has a valid and normal PO number in the database."

Probably this po_num field has two o more values (two o more rows), so they can't show it in a row (Straight table). First, Did you count the values exists by po_num?

Ricardo

[#4]

That was the push I needed.  I have multiple PO's with the exact same line items....Thanks for spark!

[#5]

Glad I could help (: