Forum Stats

  • 3,727,172 Users
  • 2,245,332 Discussions
  • 7,852,618 Comments

Discussions

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

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.

Answers

Sign In or Register to comment.