Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
SYMPTOM:
In Strategy 2019 and above, NullToEmpty function does not work within a concat statement. In some cases, an attribute may contain empty values, so the user needs to convert NULL values to empty strings. Then use it within a concat function. But statement looking like Concat(attribute01@ID, NullToEmpty(attribute02@ID)) always returns an empty value.
STEPS TO REPRODUCE:
CAUSE:
This is a known issue.
WORKAROUND:
Replace the NullToEmpty(attrib02@ID) with IF(Length(attrib02@ID) = 0, "", attrib02@ID).