Forum Discussion

AlanP514's avatar
AlanP514
Icon for Post Patron rankPost Patron
4 years ago
Solved

Replacing numerical values with text values

Hi All, I want to Replace these -2 values with N/A, Is there any possible way to replace  numerical values with text as N/A values Thanks  Alan p James
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    4 years ago

     

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could create a custom column which is null if the value of the base column is less than 0 else it is the current value of your base column. Then you can delete the base column and rename the new one.

  • AlanP514's avatar
    AlanP514
    Icon for Post Patron rankPost Patron
    4 years ago

    Could you please show one demo

     

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      4 years ago