Skip to content


Adding two numbers combines them, does not sum?

Lewis asked 5 years ago
I’m summing two numbers in a calculated formula _Purchase + _Freight and I get an error “Failed to convert parameter value from a String to a Decimal”…  when I sent this to a file I do not get (100.00 + 10.00 = 110.00), I get two numbers combined like this (100.0010.00)…  I can not figure out how to convert these to an integer…  My source is an XML file and I’m not able to figure out how to convert string to Int. Is there instructions on how this can be done?  I’ve not been able to use what is on the knowledge base either..
Lewis answered 5 years ago
I think I found a way to get this to work..  I tried using this function fn.VALUE() and it converted to integer… so this is allowing me to add two field and not have them combined

If you would like to submit an answer or comment, please sign in to the eOne portal.