There should be some simple method or direct function available for sure, which Iam not able to find it readily. I can always go with If-Then-Else. But wanted to check, for other optimized options.
If there is any negative number, I expect 0.
Any positive can be send to the output directly.
Eg:
-2 --> 0
3 --> 3
0 --> 0
Thanks!
Zero or Positive
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Tue Jan 19, 2010 4:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's a neat way of solving this with a server function:
but I'm not aware of an equivalent parallel function, so would recommend If..Then..Else for parallel jobs.
Code: Select all
Oconv(InLink.TheNumber,"R1,99999") + 0
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.