Decimal format
Posted: Mon Jul 11, 2005 5:47 am
Hi,
In a transformer I am converting decimal coming in as varchar to decimal. When I use no conversion function it automatically converts correctly. For inputs which are not in decimal format it gives default zero.
But when I use
it sets all values as 99.99, even the correct ones.
In a transformer I am converting decimal coming in as varchar to decimal. When I use no conversion function it automatically converts correctly. For inputs which are not in decimal format it gives default zero.
But when I use
Code: Select all
If IsValid("decimal",Trim(DSLink2.DECIMAL_1))=1 Then Trim(DSLink2.DECIMAL_1) Else "99.99"