Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,432
Community Members
 
Community Events
168
Community Groups

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

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?

1 answer

0 votes
Fabian Lim Community Leader Nov 04, 2021

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events