Question
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
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.
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.
Accepted Solution
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.
@GayathriG1080 Can you provide the function that invoked from expression builder with screen shots. i'm also having same issue.
@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 .