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

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