How to Convert string field to Decimal

[Anonymous]

Hi Folks,

I want to do some sum operation on the  field called CHG_AMT. 

I am executing below logic,

row1.CHG_CLASS == "OCC" &&
(row1.CHG_DESC_1 == "Late Payment Charge" ||
row1.CHG_DESC_1 == "Late Charge on Past Due Balances" ||
row1.CHG_DESC_1 == "Late Fee" ||
row1.CHG_DESC_1 == "Finance Charge" ||
row1.CHG_DESC_1 == "Late Payment Interest" ||
row1.CHG_DESC_1 == "Late payment charge on unpaid balance") ?
sum(row1.CHG_AMT) : 0

The error I am facing is with data type of CHG_AMT in  the input.

So how do I convert this to Decimal and do Sum operation?

Any help is appreciated.

Thanks

Deepak

[manodwhb]

ok,then you can use tConvertType or Double.parseDouble() in tmap to convert.

[manodwhb]

@Deepak1,did it help you?

[manodwhb]

@Deepak1,still do you have issue with this?