on 09-23-2013 10:13 PM
Hi All
While querying data from backend i am getting values for a column like this 12,500.12.This when i try to use in my BLS transaction in MII i get weird values due to conversion.Is there a way to format this value so that i get end result as 12500.12.The data type used in the FM is Dec for this column.
Please suggest.
Regards
Shweta
Shweta,
if the character for the decimal point is "." and the thousands seperator character is ",", then you
can use the Expression Function number(). This function will return what you are expecting.
For more information's, please take a look into the HELP.
BR
Pedro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The number format returned is based on the profile for the user that you are authenticating with ERP in your credential alias with. If you modify the profile on the ERP side for the user it will automatically return the values in your expected format. This way you can setup and manage technical users for the various regions rather than building in little format work arounds.
Hope this helps,
Sam
Hello Shweta,
1. Write XSLT transformation.
or
2. I believe you can convert that to string ,use stringreplace function as Padma told and then cast it back to decimal . Hope this helps.
Thanks
Hari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shwetha,
Can you try this.
stringreplace("12,500.12",",","")
Instead of value pass the row where you getting data.
Regards,
Padma Rao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.