Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I want to format the below value to two decimal places without rounding it.
Example:
ColumnA | ColumnB | Result |
171.456 | 2.321 | 169.135 |
25.45856 | 10.5426 | 14.91596 |
For info, Column A, B, and result is of type String and this result datatype in my output to remain as String.
My expected output should be 169.13 and 14.91
I have tried with the two option below:
String.format("%.2f", (Double.parseDouble(ColumnA) - Double.parseDouble(ColumnB)))
String.format("%.2f", (new BigDecimal(Var.var2).subtract(new BigDecimal(Var.var3))))
But it is rounding the value to: 169.14 and 14.92
Also, i want to know what is the difference between Big Decimal and Double? What should i use in my situation?
Thank you for your help.
Best regards,
Asadasing
Hi,
Please try below.
Regards,
@asadasing,try with below way and let me know,if you are still facing issue.
row3.newColumn2==null | row3.newColumn2.equals("")?"0"row3.newColumn2.replace(",",".")).replace(" ","")