"Invalid Formula" when trying to sum columns

I'm trying to create a formula where it sums Q1,Q2,Q3 and Q4 Actual spends so that I can then do the same thing with Q1-Q4 Projections to find the delta between them, but I keep getting the error shown on my screenshot. Any advice? 


  • Hi,



    If you need to sum the totals of your  Q1,Q2,Q3 and Q4 Actual spends, try it like this:


    SUM(`Q1 Actuals`)+SUM(`Q2 Actuals`)+SUM(`Q3 Actuals`)+SUM(`Q4 Actuals`)


    Hope this helps