How do you return a string (a word) instead of a numeric value in eazyBI?

[Micha]

Sometimes when certain values are not available, in a table I want to show text instead of the numeric outcome. 

How do I do this with MDX?

[Fabian Lim]

Hi @Micha

You can use the case statement to check first whether the value is empty. An example can be found here: https://community.eazybi.com/t/blank-field-need-to-have-existing-value/3702/2

Now, you may get some format errors since youbare mixing numbers and string values, so you may have to convert the numeric value to a string.

Cheers