marco.meli
Member
Hello,
I’m reading report data from text file and I create a collection afterwards. All fields are Text type. In this way it recreate the report in collection as it is. The issue comes when I need to iterate into Collection for calculation of those fields are e. g. Currency format. I think I need to convert them in Number and I’m using ToNumber() in front of any math operation. This cause the values are wrong converted and subsequentially the results. Here a sample attached.
PS: Even if I setup Balance Amount and Amount as Number in source collection avoiding any conversion it’s not able to format the value e.g. "0.02-" became "-2".
How can I solve this ?
Thanks.
Br.
Marco.
I’m reading report data from text file and I create a collection afterwards. All fields are Text type. In this way it recreate the report in collection as it is. The issue comes when I need to iterate into Collection for calculation of those fields are e. g. Currency format. I think I need to convert them in Number and I’m using ToNumber() in front of any math operation. This cause the values are wrong converted and subsequentially the results. Here a sample attached.
PS: Even if I setup Balance Amount and Amount as Number in source collection avoiding any conversion it’s not able to format the value e.g. "0.02-" became "-2".
How can I solve this ?
Thanks.
Br.
Marco.