on 02-25-2008 4:24 PM
Hello,
I have a qty field which we get as 400,000. I need to pass this into mapping as a whole integer.
Do let me know how to do it.
As it is a qty field , we are not expecting any decimal notation.
regards,
B.Anandh
Hello,
if you want to have no decimals you can use the standard function 'FormatNum' and define it their with a double click.
Regards
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can do one thing here ,as to use Round API to round up the values.
Source Field --->Round -
> Target Fields
Source Field ---> (Multiply with 1.00) -
>FormatNumber Or Round ---> Target Fields
Either Make the Data type as Integer for this source field or then you have to go for UDF
Thanks
Swarup
Edited by: Swarup Sawant on Feb 25, 2008 5:42 PM
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.