ROUND function to show blank/nothing

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

ROUND function to show blank/nothing

Author

Topic

pvong
Yak Posting Veteran

58 Posts

Posted - 2012-11-27 : 16:34:17

I have an expression that I just want it to show blank/nothing if it's negative from a ROUND function. Is this possible?

ROUND(IIF(a<b,"",4.2))

In my Test, if a > b, I get 4 rounded and that's great but if a<b, it shows an error. I understand it's because you can not round blank/nothing but is there a way around this? I can put a value like 0 but I really want it to show nothing.

------------------------------
Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2
Be kind to the newbies because you were once there.

LarryC74
Yak Posting Veteran

94 Posts

Posted - 2012-11-28 : 13:11:31

Why not use:

Round(IIF(a>b,4.2,""))

Or

Round(IIF(a>b,4.2,Nothing))

Or

ROUND(IIF(a<b,Nothing,4.2))

Everyday life brings me back to reality