topic Re: Count Empty Fields in App Development

Count Empty Fields

Daniel1908 — Wed, 24 Nov 2021 17:30:20 GMT

Hello Together,

I am using the below expression.
Unfortunately the count for the empty fields (Address & Address_2) does not work.

[Address]-={'*'}
[Address_2]-={'*'}

Do you have any ideas?

=Count(aggr(only(distinct{<[Product]={'1'},[Address]-={'*'},
[Product_Text]={"=WildMatch(Left(Product_Text,20),'*New*')"}>}Product_Number)
& only(distinct
{<[Product]={'1'},[Address_2]-={'*'},[Product_Text]={"=WildMatch(Left([Product_Text],20),'*New*')"}>}Product),Product,Options))

Kind Regards,
Daniel

Re: Count Empty Fields

MarcoWedel — Wed, 24 Nov 2021 19:52:17 GMT

{
$<[Product]={'1'},[Product_Text]={"=WildMatch(Left([Product_Text],20),'*New*')"}>
-
$<[Address_2]={"*"}>
}

Re: Count Empty Fields

Daniel1908 — Thu, 25 Nov 2021 12:16:54 GMT

The expression shows ok but does not count the empty field for Adress and Adress_2.

Any further ideas?

Thanks for your help

Kind Regards,
Daniel

Re: Count Empty Fields

marcus_sommer — Thu, 25 Nov 2021 15:15:07 GMT

I assume that the values aren't empty else NULL. NULL isn't be stored in any way could be therefore not selected and also not be excluded. AFAIK there are ways to calculate them with an indirect set analysis but it's not always trivial.

Easier is it in many cases to replace the NULL within the script with real values with any of the NULL variables or with measures like:

if(isnull(Field), 'NULL', Field) as Field

if(len(trim(Field)), Field, 'NULL') as Field

which makes these values accessible. You may apply here any string you like maybe also ' ' and should such empty/default value be disturbing you may double the field and using one within the UI and the other only for the set analysis.

- Marcus

Re: Count Empty Fields

Daniel1908 — Thu, 25 Nov 2021 16:31:37 GMT

Thanks Marcus,

This worked perfectly.

Kind Regards,
Daniel