"Invalid Formula" when trying to sum columns

user006501
user006501
in Dataflows

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

  • RGranada
    RGranada 🟢

    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

     

     

    Ricardo Granada 

    [email protected]

    **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.

Categories