Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 28, 2012 04:51 AM by Ashutosh Pathak
Nov 27, 2012 08:29 PM|LINK
I have an expression that I just want it to show blank/nothing if it's negative from a ROUND function. Is this possible?
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.
Nov 27, 2012 08:55 PM|LINK
Can you wrap it in another IIF and compare it to zero and if it is equal then make it blank, otherwise make it the value of the round?
Nov 28, 2012 12:21 AM|LINK
Nov 28, 2012 04:51 AM|LINK