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.

     

     

JayHerrera's avatar
JayHerrera
Icon for Advocate I rankAdvocate I
7 years ago

Anonymous  What data type are your "start" and "end" data fields? 

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:)