Round function not working with Null values
Posted: Thu Jun 06, 2024 8:26 am
Hi there
I have an attribute value - called "myvalue" in the following - which is a number and can be Null sometimes.
For a field in my report I tried to use this expression, which does not display anything if the value is Null though. If I remove the Round-function or the value is not Null it works. Any suggestions?
Thank you in advance.
I have an attribute value - called "myvalue" in the following - which is a number and can be Null sometimes.
For a field in my report I tried to use this expression, which does not display anything if the value is Null though. If I remove the Round-function or the value is not Null it works. Any suggestions?
Code: Select all
{IIF(myvalue == null,"unknown",IIF(myvalue == 0,"unknown",IIF(myvalue == null,"",Round(myvalue,2))))}