Skip to Content
0
Nov 09, 2007 at 02:02 PM

BLS nullnumber assignment

25 Views

Hi, I'm having difficulty assigning a nullnumber to a transaction's local property.

First I generate a local propery xml document. I then need to do a calculation with the content of this xml file. If one of the inputs to the calculation is a "" or NA, then I want the output to be a nullnumber ie: NA.

This logic is done using:

if(

Local.ReturnedDocXML{/Rowsets/Rowset/Row[./SubItem=="#Local.Rpt_ClosingStock_Measured#"]/Pt} !="NA"

and

Local.ReturnedDocXML{/Rowsets/Rowset/Row[./SubItem=="#Local.Rpt_ClosingStock_Measured#"]/Pt} !="",

Local.ReturnedDocXML{/Rowsets/Rowset/Row[./SubItem=="#Local.Rpt_ClosingStock_Measured#"]/Pt}

-

Local.ReturnedDocXML{/Rowsets/Rowset/Row[./SubItem=="#Local.Rpt_ClosingStock_System#"]/Pt} ,

nullnumber )

The output of this logic is assigned to a local property of type double. If the condition occurs where the value should be a nullnumber, the local property gets a value of 0. If I have a tracer action block with the same logic in the message link, the output is the NA as expected. However the local property's value is still 0.

Any ideas about this. I'm assuming that nullnumber is not shown as a 0. It's normally a "---" in the grid or an NA or "" in the xml output from what I can remember.