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
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.
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
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.
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 .