Replace NULL with dash or blank in column with type 'Date' in SAC

[Kristina33]

Hi all,

Is there any way to convert null values of Date type Dimension with dash ('-') or blank (' ') in SAP Analytics Cloud?

I tried creating Calculated Dimension, but I've got an error: Dimension of type 'date' cannot be used in Calculated Dimension. Also, I've tried to convert date to string but function TOTEXT() is not allowed for Date type.

Thanks in advance.

[GiriRaaj]

Hi Kristina,

If you're using a Date type dimension, replacing a null with non-date characters (like a dash or space) could require changing the data type of the output (e.g., converting the result into a string format). Date dimensions don't natively support non-date characters.

Hope it helps.

regards,

Giri