TOFLOAT

TOFLOAT(data);

Often needed when using operators in other formulas. It converts the value to FLOAT which ensures a correct comparison on lookup when e.g. transferring a field to a FLOAT field or if you need to calculate on the value.

 

Example:

##IF("Account Balance" < TOFLOAT(100),'Send Warning','OK')
Convert the value to FLOAT which makes it compatible for comparison with the Account Balance field.