How to sum values with a dollar sign?
Sample Data set:
To sum the above data set, use Tabular Transformation -> Advanced Query Command to perform the following operations:
Strip the "$" sign
Sum the values
Preserve two points of precision
select printf("%.2f",sum(trim(replace(AMOUNT,'$', '')))) as AMOUNT from fact
If you need additional support, please contact email@example.com