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"
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)