Im trying to get an IF statement to show a value captured or N/a if > or < than a certain amount

[#1]

Hi there,

I need to highlight whether data captured is over a certain threshold.

Ideally I want to create an IF statement that if the value is >xx it shows the value captured and if not, it shows 'N/A'.

This is what I've tried.... IF([Trade Value] >(XX),[Trade Value],'N/A') as [Trade >xx]

It seems to load ok when reloading the data but the results are unexpected as I only receive N/A's when the data set has values greater than the threshold.

any help will earn you a coffee and a doughnut

[nizamsha]

TableA:

Load * ,if( [Notional Trade Value]>75000, [Notional Trade Value],'NA') as NewNotational_TradeValue;

Load

[FundsInformation/Trade Value] as [Notional Trade Value]
FROM [\\www.avivaworld.com@...........] (XmlSimple, Table is [myFields]);