Flow Designer - getting string value outputted to a decimal variable in a custom table

[Peter Williams]

good day,

i am designing a flow designer to table an RITM variable and output the results to a custom table.

What i am having issues with in the Flow designer, the string value i am outputting is formatted as such

$56.00 and its trying to write to a decimal field in the custom table however nothing gets forward to it

i tried a custom script to parseInt of the RITM string value but nothing is happeing

i tested in exporting the value to another string in the custom table and that works

but nothing i do in the flow designer will allow the value $56.00 or anything with the $ in the front to be written to the custom table field

please help

[Tony Chatfield1]

Hi, did you debug the result of your parseInt() conversion?
Did you remove any non numerical values IE $ before the string to int conversion?
If not, the result is possibly NaN

var test = '$56.00';
var myResult = parseInt(test);
gs.info(typeof myResult + ' | ' + myResult);

var test2 = '$56.00';
test2 = test2.replace('$', '');
var myResult2 = parseInt(test2);
gs.info(typeof myResult2 + ' | ' + myResult2);