Fallback value as 0 or 'NA' For named query binding result null/ NULL?

Ignition
,
1

How to configure Fallback value as 0 or 'NA' to component in perspective while binding with named query result null/ NULL?

It is showing overlay error on Perspective component.

2

Query null transform
Query null transform630×717 59.9 KB

  1. Named query binding.
  2. My test query.
  3. Add a transform ...
  4. ... of the Expression variety.
  5. Test for ìsNull().
  6. The result.
2 Likes
3

Alternatively,

you can use the coalesce expression

image
image787×763 46 KB

3 Likes