BLS nullnumber assignment
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:
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.
Jeremy Good replied
You can't assign the null value to a TRX property, as all numerical properties will default to their effective minimum. The null functions in the link editor are only intended for the IllumDoc data value elements to emulate the behavior of a straight query results and the null response from the data source. Even though I always prefer to keep data types consistent, maybe this would be a good place to use a string data type and manage the Local property being "" as a null in your logic. A little messy of course, but it is what it is I guess.