Question
Convert Amount into continuous Numeric value
Hi All,
I have a requirement to convert Amount associated with Currency($) and Comma(,) into continuous numeric value.
For Ex:
Input - $150,000 Output - 150000
Input - $12,000,000 Output -12000000
Is there any OOTB function to achieve above requirement? Appreciate your help
Thanks in advance
have you tried using this pxReplaceAllViaRegex() ?
Can you provide some context for this problem? This post is tagged as Reporting, are you trying to retrieve a text value representing a currency amount as a numerical value in a report?
You can use OOTB - replaceAll,pxReplaceAllViaRegex functions, but you need to first convert the input type to string since these methods expect input as String.
If this is a string stored in a database column, and you are trying to convert it for a report, you can define an SQL Function Alias using the SQL REPLACE function:
REPLACE( REPLACE( column_name, ',', '' ), '$', '' )
Any Inputs are appreciated