Filter Non Numeric Data

[Ink]

Hi,

I have a report based on an xml file
The xml contains a list of 3 columns which contain numeric and non numeric data e.g

Item Qty100g QtyPortion
First 10 50
Second 20 100
Third 1 Tr
Fourth 0 N/A

I have 2 databand on my report - the first renders the xml 'as is' displaying all the values.
The second contains a barchart graphing the values. Obvioulsy the graph fails if the value is non-numeric.
Is there a way to filter the data just for the graph data band to exclude the non numeric values?

Thanks,

jon.

[Alex K.]

Hello,

Please send us your report with test data for analysis.

Thank you.