Including all values

[smilingjohn]

Hi All, 

IN my data I have the values like null and empty  where as I need to consider those values which are empty and null .

but this is considering only empty values or - values and neglecting something like 'null' .

Thanks in Adance

[Nicole-Smith · Accepted solution]

You can join your two sets together with an OR by using + between them:
count({<ID={"=Len(Sales_ID&Employee_ID)<=0"}>+<Sales_ID={'null'},Employee_ID={'null'}>}ID)

In this case, it will count it if either of the sets are true.

[Chanty4u]

try this

in script:  NULLASVALUE *;

in front end expression :

count({<Sales_ID={"*"},Employee_ID={"*"}>}ID)