How can i count empty/blank string values in a expression ?

[#1]

Hello

How can i count empty/blank string values in a expression ?

[#2]

try
=Count(Null())

=Sum(Null())

[sinanozdemir · Accepted solution]

Maybe try something like this:

For empty/blank values = Count({<[Your Dimension Name] = {''}>} [Your Dimension Name])

For null values = Count({1 - <[Your Dimension Name] = {"*"}>} [Your Dimension Name])

[#4]

that doesnt work

I have already the count of actual NULL value by using NullCount(ProductModel)

But, now i want to count the empty string fields inside ProductModel , how can i do that ?

[#5]

= Count({<[ProductModel] = {''}>} [ProductModel])

= Sum( {$<ProductModel = {''}>} ProductModel )

[Anonymous]

hi akintosh,

try as below:

In script:

load *,
if(LEN(TRIM(FieldName)) = 0,'1','0') Flag
From ......;

In expression:

count({< Flag = {1}>}FieldName)

[sinanozdemir]

Please see my original answer.

[#8]

worked perfectly, thanks!

[sinanozdemir]

You are welcome.