SOLVED
Negative values to zero
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
neromerob
10 - Fireball
06-22-2022
08:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello to everyone.
I´m looking for a way to change multiple negative values to zero that are present in different fields.
thank you.
Solved! Go to Solution.
4 REPLIES 4
17 - Castor
06-22-2022
08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
06-22-2022
08:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
20 - Arcturus
06-22-2022
10:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You've got two (2) replies from @IraWatt and @DataNath already, but I'll add a third. I read your post with a slightly different function in mind. The smallest number (value) that you want present in your data is zero (0). This logic is easy to implement with:
MAX([_CurrentField_],0)
You'll find more uses for this later in your Alteryx life.
Cheers,
Mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
17 - Castor
06-22-2022
10:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Every day is a school day! Wasn’t aware of that option, cheers @MarqueeCrew!
