2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you uninstall it, and then install the latest 2022.1.1.30961 version.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Negative values to zero

neromerob
9 - Comet

Hello to everyone. 

 

I´m looking for a way to change multiple negative values to zero that are present in different fields. 

 

negative_to_cero.JPG 

 

thank you. 

 

 

 

 

4 REPLIES 4
DataNath
12 - Quasar

Hey @neromerob, you can do this with a Multi-Field Formula like so:

 

DataNath_0-1655912733169.png

 

DataNath_0-1655912672996.png

 

IraWatt
15 - Aurora

Hey @neromerob,

you can use a multi field formula:

IraWatt_0-1655912783988.png

Any questions or issues please ask :)
HTH!
Ira

 

MarqueeCrew
19 - Altair
19 - Altair

@neromerob ,

 

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.
DataNath
12 - Quasar

Every day is a school day! Wasn’t aware of that option, cheers @MarqueeCrew!

Labels