MultiField Formula

[Riot]

I have a list of fields and I want to change the information in them. What I am trying to do is 

IF [_CurrentField_] = 1 THEN 1
ELSEIF [_CurrentField_] = 2 THEN 1.08
ELSEIF [_CurrentField_] = 3 THEN 2.6
ELSEIF [_CurrentField_] = 4 THEN 3.4
ELSEIF [_CurrentField_] = 5 THEN 4.2
ELSEIF [_CurrentField_] = 6 THEN 5
ELSE [_CurrentField_]
ENDIF

But that didnt seem to change the fields I selected. They stayed the same. 

Any ideas ? I imagine i am doing it wrong. 

[MarqueeCrew · Accepted solution]

I do assume that you are using a multi-field formula and that you've selected numeric fields.

Depending upon your alteryx version, you might need to change '=' to '=='.

You might also try:

Switch([_CurrentField_]),[_CurrentField_],1,1,2,1.08,3,2.6,4,3.4,5,4.2,6,5)

Thanks,

Mark

[tom_montpool]

Make sure that you turn off the "Copy Output Fields and Add [New_] as a {Prefix}" option.

In my opinion, this should be in the running for "Worst....Default....Ever"!!!

Have fun!

[Riot]

I switched my output from INT16 to Float because INT16 was rounding up to the nearest whole number. Can I change that or should I just use a float ?