SOLVED
Replace 0 value with <1
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AMCM0806
6 - Meteoroid
‎05-22-2023
12:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I have a data set that I would like to replace 0's with <1. However, this column includes numbers like 10, 20, 30, etc. so the replace formula is changing 10 to 1<1. Is there a formula that will look for isolated 0's?
Replace([Runway in years], "0", "<1")
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Developer Tools
- Reporting
3 REPLIES 3
binuacs
21 - Polaris
‎05-22-2023
12:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AMCM0806 some thing like this?
nagakavyasri
12 - Quasar
‎05-22-2023
01:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-22-2023
02:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was the simpler solution that worked. Thank you!
