How to round the price value in data?

Anonymous — Sat, 16 Nov 2024 05:43:43 GMT

Hi Team,

I have a data like this with a column MYR , I need them to give a round value, For Ex: 625509.34 means required output 625510

Source Data type is Double , destination anything you want or same ? Empty records should be replaced with 0 as well.

Thanks & Regards,

Prabhakaran

Re: How to round the price value in data?

bhagyarekha — Tue, 28 May 2019 08:40:56 GMT

input string output double

in tmap expression builder write down

row1.price!=null?Double.parseDouble(row1.price):0

in output tmap

Math.ceil(Var.var1)

Regards

rekha