Hi,
I am facing problems with Decimal numbers arithmetic operations, esp for (23,3) format decimal numbers.
The forum search results guide me to the usage of String Math functions, like, SDIV and SMUL etc.
I tested them using a routine and the results are correct.
But I am unable to use these functions on the Field Derivation. Can't I use them there ? Can these be used only using a Routine ?
using String Math functions
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
using String Math functions
Share to Learn, and Learn to Share.
I've only used them in routines. I'm not positive but have you tried just typing them in and compiling the job regardless of the fact that it stays red in the derivation?
Sometimes that's just a matter of the function not being in the DSParams file so it's not recognized as valid but works fine when the job runs. And sometimes it just means you need to put it in a routine.
If the job compiles and runs, put an annotation in on the subject so no-one freaks out when they find 'invalid' syntax in the job.
Sometimes that's just a matter of the function not being in the DSParams file so it's not recognized as valid but works fine when the job runs. And sometimes it just means you need to put it in a routine.
If the job compiles and runs, put an annotation in on the subject so no-one freaks out when they find 'invalid' syntax in the job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto