Negative values to zero

[neromerob]

Hello to everyone. 

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

 

thank you. 

[DataNath]

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

[IraWatt · Accepted solution]

Hey @neromerob,

you can use a multi field formula:

Any questions or issues please ask :)
HTH!
Ira

[MarqueeCrew]

@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

[DataNath]

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