Subject:NaN(not available) value replaced by empty cell in XML Report? Author:(Deleted User) Date:21 Jan 2009 03:28 AM
I created an xml report from an xml file. The cells for which no value is available in the xml tags get an Nan value. Can I replace these by empty, so nothing is visible in these cells in the report?
Subject:NaN(not available) value replaced by empty cell in XML Report? Author:(Deleted User) Date:21 Jan 2009 09:55 AM
Hi Cynthia,
you can enclose the operation inside a "if" block to ensure there is data to work on; or you could also change, in the Decimal Format property window, the value for the NaN property to be an empty string.