Parse Error at char(23): Formula: tried to apply numeric operator to string value

[Karl_Spratt]

Hi Community 

Need some help please getting this error message 

Error: Formula (5): Parse Error at char(23): Formula: tried to apply numeric operator to string value (Expression #1)

I tried to change it to 

tonumber(Round([Value]*1.2,1))

but it still doesn't like it, can someone please explain how to fix this.

TIA,

Karl. 

[Emmanuel_G]

@Karl_Spratt 

Can you try to convert the field Value in numeric type ( double by example ) with a select tool before formula tool ?

You cannot multiply a string with 1.2 which is numeric.

Let me know if there is always any issue. 🙂

[messi007 · Accepted solution]

@Karl_Spratt,

Please see below :

Attached the workflow,

Regards,

[Karl_Spratt · Accepted solution]

Thanks messi007 that worked. 

Community than you all.. 

[Karl_Spratt]

Thanks all for your help the different ways to do this all worked. I really appreciate all your help and advice.

The community help is really brilliant so tank you all..

Cheers,

Karl.