Show value

[soniasweety]

Hi all,

in my strighttable  i have  ID as column  but it showing blank  instead of that i want to show the  unknown there

how to do?

[sibin_jacob · Accepted solution]

Try This one

If(len(Trim(ID))=0,'UNKNOWN',ID)

If it is not working, try the below.

If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID)

[soniasweety]

i dont want to do in calucalted dimension how can i do into front end only?

[MK9885]

Maybe

If(Len(Trim(ID)) = 0, 'Unknown',ID)

same answer as Sibin gave

[vishsaggi]

You can use what Jacob suggested in your straight table Dim ID. Just click edit for your ID field then type like

Calculated dimension

= If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID)

OR

= Aggr(If(isnull(ID) or len(TRIM(ID))=0,'UNKNOWN',ID), ID)

[sibin_jacob]

Sorry, I didn't get you. what you mean by front end?

Can you please explain little more on your requirement ?

The above formula will work in a script as well as calculated dimension.