In the formula how can I convert number to string in a particular case

User_8PPKU

Imagine you have a field that is a number (for example a):

I want to convert the field value (in the formula) to the string 'NA' when the data is null .

How can I do this?

I tried with:

CASE WHEN a IS NULL THEN 'NA' ELSE a END

but it is not work .

Regards.

SriniVEERAVALLI

convert it char and then validate.

User_8PPKU

if the field is a number I can not apply the char() function.

Gianni Ceresa

You can't have a mixed datatype in the same column: if 'a' is a number, 'N/A' should be a number (which is impossible).

If you really want 'N/A' then every single number in that column should also be a text, which is maybe not what you want...

CAST() can be used to convert any datatype.

User_8PPKU

I saw that it is possible:

I followed the instructions of this article, an it works well :

https://creativeme1807.wordpress.com/2015/10/06/steps-to-replace-null-values-in-an-obiee-pivot-table-with-no-data-or-na-or-no-description-using-custom-data-format/