Writing Conditional Statements

I have a data set of apportionment percentages. The data type is double. There are a few negative percentages that I want to replace with zeros. I tried IF [Apportionment %] < 0 THEN "0" ELSE [Apportionment %] ENDIF, but I get an error message that says the formula "Apportionment %" resulted in a string but the field is numeric. Use ToNumber(...) if this is correct. The field "" is not contained in the record. What am I doing wrong here?? New to Alteryx, so please keep that in mind

Datasets

Accepted answers

bbak

That means that you have another formula down below that doesn't have the output column selected.

bsolove

That worked. Thank you!

All comments

MarqueeCrew

"0" is a string. Please try:

IF [Apportionment %] < 0 THEN 0 ELSE [Apportionment %] ENDIF

Another fine choice is:

Max(0,[Apportionment %])

Cheers,
mark

bbak

You need to take the 0 out of the quotes. By putting it in quotes you are saying that you would like to return a string. Removing the quotes should do the trick!

bsolove

If I remove the quotes, the error says the field "" is not contained in the record. I get the same error if I use the Max formula above.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703