IIF Statement and Divide a Column to a 100 and add 1 before decimal point

[nsenriquez]

Hi I'm trying to resolve this formula but I couldn't find any discussion about this. I have an existing formula I'm using in Access Database IIf([% flag]="P",1+([Rate]/100),[Rate]) but would like to use this in Alteryx workflow I have.  Thank you in advance guys!

% Flag	Rate	Increment (I'm looking for this answer)
P	5	1.05
P	31.25	1.3125
P	37.5	1.375

[jdunkerley79 · Accepted solution]

A formula tool with that expressi9on should produce exactly what you want. Make sure to select a double as the type for the new column.

[nsenriquez · Accepted solution]

Thank you @jdunkerley79 for helping out. It worked!