How to write a complex conditional SRSS expression

See more:

SQL-Server-2008R2

reporting

I have a result set in SRSS like I have mentioned below. I need to round the Elements which are not - to one decimal. How I can do this in SRSS 2008 reporting services.



Name Sio2

HRSG11 -

HRSG12 -

HRSG13 -

HRSG14 1.0212

HRSG15 2.233

HRSG21 23.11

I wrote like this

IIf(Fields!SiO2Lab.Value <> "-",Format(Int(Fields!SiO2Lab.Value), "N0"),true)

But it gives me the output like


Name Sio2

HRSG11 #Error

HRSG12 #Error

HRSG13 #Error

HRSG14 1

HRSG15 2

HRSG21 23

The underlying datatype of SiO2 is NVarchar(Max)

Please help me

Regards
-pep