Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello, this should work
Count({<Vendor = {''}>} Vendor)
it counts 0, when i should get a number instead
When you write '-' does it represent a null value?
yes, it does 🙂
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