Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_8PPKUApr 12 2021

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.

This post has been answered by User_8PPKU on May 11 2021

Jump to Answer

Added on Apr 12 2021

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

157 views