Sum Column Calculations With $

Hello,

I'm trying to build a simple report that shows a list of certain accounts and a sum of their ARR. However, when I try to sum the ARR column, the report doesn't return anything. I suspect this is because the ARR includes a $, as I tested this same thing with other numbers that didn't include symbols and the summing worked properly then

I can't remove the $ as it's coming straight from Salesforce. This seems like it should be easy to do. Is there something I'm missing?

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1693432/RackMultipart20180116-30432-1gk3ljz-Screen_Shot_2018-01-16_at_4.02.02_PM_inline.png?1516136876

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1693432/RackMultipart20180116-30432-1gk3ljz-Screen_Shot_2018-01-16_at_4.02.02_PM_inline.png?1516136876

Dallis King

752 Points

Posted 9 months ago

9 months ago

Jeevan Chamarthi, Employee

368 Points

Hi Dallis,

Column calculations are currently not supported for multi-currency columns. Can you please check if ARR is a multi-currency column?

Thanks,
Jeevan

Comment

2018-01-17T18:36:28+00:00

Dallis King

752 Points

Ah I see... Ok I figured out a workaround where I use a converted ARR field that is all in the same currency. Thank you!

3 months ago

Shiv Kumar Katiyar, Employee

1,532 Points

Few days back, a similar request came to support from one the customer, so just wanted to check if there is any future plan for this functionality in multi-currency org?

Comment

Related Categories

Reports & Dashboards