I have a bunch of data in the excel sheet and from talend I read those data and insert into the table. But when the amount is negative it still inserted as a positive number and that's why I am getting the wrong total of amount.
Example :: value = (100) is equivalent to -100.
Negative value comes in ().
I tried this but it's not working.
StringHandling.RIGHT(row27.line, 1).equals("(") ? "-" + StringHandling.EREPLACE(row27.line, "(", "") : row27.line
@TRF Can you please help me out.
Solved! Go to Solution.