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"