"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? 

Comments

  • 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