Formula help

[htalteryx]

Can you please help me with a formula to get the result on the right?  I tried an IF CONTAIN formula, but it's not working.

110000.6

110000.3

[htalteryx]

I got an error.  How do I update the data type in the formula tool?  It's grayed out for me.

[cmcclellan]

If you are changing the formula on an existing field you can't change the datatype in the Formula tool (use a Select tool before to achieve this).  If you create a new field in the Formula tool then you can set the datatype.

[htalteryx]

Can you please look at my workflow I provided above and let me know how I can fix?  Thank you so much for your help and continued patience!

[cmcclellan]

Don't create Field2 in the Text Input, create it in the Formula tool :) 

see attached.

[cmcclellan · Accepted solution]

Can you mark answer/s as correct if it provided the solution for you please ?

[htalteryx]

Can I email you if I have further questions? Or should I reply to the thread?

[cmcclellan]

Always better to post in the forums :)   If you still have a problem with the formula then post here, if it's a new issue then start a new thread.

I just realised you are in Irvine as well, just down the road from Alteryx HQ :)