Question
Ford Motor Company
US
Last activity: 29 Apr 2022 6:55 EDT
Decimal to comma separated currency value?
How do we achieve conversion from decimal/integer number to comma separated currency value without the currency symbol?
what i want to achieve :
Number > USD
1000000 > 1,000,000
***Edited by Moderator Kayla to update Platform Capability tags****
Accepted Solution
Updated: 22 Jun 2020 13:31 EDT
Pegasystems Inc.
US
Updated: 14 Jun 2021 7:38 EDT
.
IN
You can use the Currency Control and in the Presentation tab mention Separators as "Yes". Please find the below screenshot for more details.
Pegasystems Inc.
US
I don't think you can display using a Currency control without displaying some kind of currency "indicator". If you don't want say, a dollar sign ('$') you can opt for different indicatots:
If you don't want any symbol at all, don't use the Currency control. You can opt to use separators for other numeric controls.
Updated: 22 Jun 2020 11:16 EDT
Ford Motor Company
US
I want this value to be sent as a request parameter. I am not looking for presentation/UI,.
Accepted Solution
Updated: 22 Jun 2020 13:31 EDT
Pegasystems Inc.
US
Then this will depend on the context. This type of string manipulation can be done using Java, in a step for instance, if you are in an activity. It can also be done using SQL functions, if the value is coming from the database.
Ford Motor Company
US
Since there are no OOTB function for this I created a Java function and invoked it from the expression builder.
Capgemini
US
@GayathriG1080 Can you provide the function that invoked from expression builder with screen shots. i'm also having same issue.
Capgemini Nederland BV
NL
@Suresh4347@GayathriG1080 by chance ,if you get the the fuction body that u have created or go it .Please share with me as well as we are also need same requirement .
Then this will depend on the context. This type of string manipulation can be done using Java, in a step for instance, if you are in an activity. It can also be done using SQL functions, if the value is coming from the database.