Sum Column Calculations With $

  • 2
  • Problem
  • Updated 3 months ago
  • Acknowledged
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?

Photo of Dallis King

Dallis King

  • 610 Points 500 badge 2x thumb

Posted 3 months ago

  • 2
Photo of Jeevan Chamarthi

Jeevan Chamarthi, Employee

  • 338 Points 250 badge 2x thumb
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
Photo of Dallis King

Dallis King

  • 610 Points 500 badge 2x thumb
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!