Returning Text if JOIN(COLLECT(...)) unable to make a reference

Torsten Rich-Wimmer

I noticed that, if JOIN(COLLECT(...)) is unable to make a reference, it just returns null. I am drawing a blank. How can I cause it to return text instead?

Kelly Moore

Hey @Torsten Rich-Wimmer

Please provide your current formula to enable the community to help you troubleshoot.