Count the quantity of "-"

[Nemo1]

Hello everyone,

I am trying to count the number of "-" from a dimension.. 

for some reasons it is not working out.. 

this is the formula: Count({<Vendor = {'-'}>} Vendor)

thanks

[Clement15]

Hello, this should work
Count({<Vendor = {''}>} Vendor)

[Nemo1]

it counts 0, when i should get a number instead

[Clement15]

When you write '-' does it represent a null value?

[Nemo1]

yes, it does 🙂

[marcus_sommer]

NULL means there is nothing - it's not a stored value and could be therefore not accessed or calculated. A quite simple and very common approach in such use-cases is to replace NULL with a real value in the script, maybe like:

if(len(trim(Vendor)), Vendor, 'no Vendor') as Vendor