Round function not working with Null values

[aletopo]

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?

Code: Select all

{IIF(myvalue == null,"unknown",IIF(myvalue == 0,"unknown",IIF(myvalue == null,"",Round(myvalue,2))))}

Thank you in advance.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.
Please send us a sample report with test data for analysis.

Thank you.