Handling NOVALUE channel

[Durai26]

Trying to create a report layout template with full of expressions in it. Expected to have all cell values with 2 decimal accuracy.

In the above table, for a parameter3 on the column 4, it shows "NOVA"

Because in some cases, that particular channel is having "NOVALUE" in maximum property attribute. In such cases, would like to have an empty cell. How to do this in expression based report template?

Expected:

  * if numerical value ==> 2 decimal accuracy

  * if "NOVALUE" ===> Empty cell

Expression used: @@Str(Data.GetChannel("/Parameter_3").Properties("maximum").Value, "d.dd")@@

is it possible to have if condition based expression in a table?

Thanks in advance,

Durai

[Walter_Rick]

Hi Durai,

In case of NoValues in a table column the default is an empty cell.

I have tested this in DIAdem 2022

Greetings

Walter

[gsklyr · Accepted solution]

Hello Durai,

Use:

@@FormatNumber(Data.GetChannel("/Parameter_3").Properties("maximum").Value, 2)@@