DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Handling NOVALUE channel

Solved!
Go to solution

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

Durai26_1-1670663850275.png

 

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?

 

Durai26_2-1670663942080.png

 

Thanks in advance,

 

Durai

 

0 Kudos
Message 1 of 3
(946 Views)

Hi Durai,

 

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

 

Walter_Rick_0-1671016471176.png

 

I have tested this in DIAdem 2022

 

Greetings

Walter

 

0 Kudos
Message 2 of 3
(881 Views)
Solution
Accepted by Durai26

Hello Durai,

 

Use:

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

Message 3 of 3
(755 Views)