Skip to main content
dallis_king
dallis_king
Contributor ⭐️⭐️⭐️
Jan 16, 2018 9:08 PM UTC
Question

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?

    4 replies

    jeevan_chamarthi
    jeevan_chamarthi
    Contributor ⭐️⭐️⭐️
    Jan 17, 2018 5:08 AM UTC
    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
    Translate
    dallis_king
    dallis_kingAuthor
    Contributor ⭐️⭐️⭐️
    Jan 17, 2018 6:36 PM UTC
    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!
    Translate
    shiv_kumar_katiyar
    shiv_kumar_katiyar
    Gainsight Employee ⭐️⭐️
    Jul 17, 2018 4:17 PM UTC
    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?
    Translate
    jason_metzler
    jason_metzler
    Helper ⭐️⭐️
    Aug 19, 2019 3:48 PM UTC
    Our VP of CS would also like to be able to calculate the sum of columns with currency. +1 for RiskIQ

    Translate
    Terms & ConditionsAccessibility statement