Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Replace BLANK to another text

I have start and end data columns Some End data is blank. so Chart shows that data (Blank) I would like to change that (Blank) to another text. I tried New Measure = if(ISBLANK([Original Measure]...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous seems like your [original measure]  is not of text type, you can do something like this

     

     New Measure = if(ISBLANK([Original Measure]),"Presence",
FORMAT([Original Measure], "######0.00" ) )

    basically you are converting your original measure to text, you can change the format string based on your need.

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous seems like your [original measure]  is not of text type, you can do something like this

 

 New Measure = if(ISBLANK([Original Measure]),"Presence",
FORMAT([Original Measure], "######0.00" ) )

basically you are converting your original measure to text, you can change the format string based on your need.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, Your Answer is great! I try it and work!

My data is datetime format, so use your code like this:

EndTimeFix = IF(ISBLANK([EndTime]),"Presence", FORMAT([EndTime],"General Date"))
 
Thank you for your help:)