Value(left(0.5,4)) returns 0 when expecting 0.5

Topic Labels: Formulas
706 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Am I doing something wrong here? For decimal values inside a string, “0.5 some text” or “12.1 some text”, when I use, Value(left(0.5),4), I do not receive the decimal value. It will return the first integer of number. Is there a different want to return the decimal number found on the left most side of the string as mentioned above?


1 Reply 1

Hi @Jason_Calaiaro - your formula works fine for me:

Screenshot 2019-07-15 at 12.14.32.png

Combo field is:

VALUE(LEFT(Name, 4))

Make sure the formatting on the field is set to decimal

Screenshot 2019-07-15 at 12.14.44.png