Decimal Point

raju4u · Post by **raju4u** » Mon Feb 07, 2011 10:29 pm

Hi,

I am getting the data like 80.123,23.123
means after decimal point i am getting 3 digits ,i need to multiply the data and get the results up to 3 decimal point only(121.122).
source is text file here.
do we have any functions for this transformer..

Please let me know..

chulett · Post by **chulett** » Mon Feb 07, 2011 11:02 pm

Sorry but I can't make any sense out of your question. Can you provide some actual data examples (rather than made up ones) and then the results you need to get from that data? Perhaps then someone can help you get there. Might also help if you exanded on what "multiply the data" means.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 08, 2011 12:14 am

What happens if you convert each field to decimal using StringToDecimal() function then multiply the two together into an output field that has a scale of 3?