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.
Can you mark answer/s as correct if it provided the solution for you please ?
I have a lot of values containing .6 and want to change them to .3
There's a little converting that you'll need to do for those string functions to work on that numeric value. Try this:
tonumber(replace(tostring([Field1]),".6",".3"))
Formula Breakdown:
1) You're going to replacing the string ".6" with ".3", but this has to be performed on a string value. Convert the value ([Field1]) using "tostring([Field1])".
2) Then perform the replacement using "replace(tostring([Field1]),".6",".3")"
3) Once you have that replacement done, convert the final result back into a numeric value using "tonumber("
I wouldn't convert to string, I'd just do this:
Code is:
if round([Field1] - floor([Field1]),.1) = 0.6 then [Field1] - 0.3 else [Field1] endif
