Expression if EMPTY VALUE or Null

[#1]

Hey guys,

Im reading an SQL query from and populating a table, which works fine!

Now I would like to set a where statement so to speak in an expression. so that rows onyl shows where my column: Registration isNull or has an empty value.

[sunny_talwar]

May add this in your expression:

{<Registration = {"=NullCount(Registration) > 0"}>}

or

{<Registration = {"=Len(Trim(Registration)) = 0"}>}

[Kushal_Chawda]

Which database it is? Oracle or Sql server?  want to restrict at back end or front end?

[sunny_talwar]

Alternatively create a flag in the script like this:

If(Len(Trim(Registration)) = 0, 1, 0) as Flag

and then use the flag

{<Flag = {1}>}

[#5]

SQL server

[Kushal_Chawda]

try

Sum({1-$<Registration ={'*'}>}Value)

[#7]

Not working 😕

[#8]

Not a sum just a if function

[Kushal_Chawda]

still not clear what you want to achieve it. Please elaborate.

[sunny_talwar]

I think creating the flag in the script will be the most easy way to do it.