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


  • RGranada
    RGranada Contributor




    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



    Ricardo Granada 


    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.