"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 Q1Q4 Projections to find the delta between them, but I keep getting the error shown on my screenshot. Any advice?
0
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
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.0
Categories
 10.7K All Categories
 13 Getting Started in the Community
 41 Beastmode & Analytics
 2.1K Data Platform & Data Science
 59 Domo Everywhere
 2.7K Charting
 2.5K Ideas Exchange
 1.3K Connectors
 362 Workbench
 303 Use Cases & Best Practices
 503 APIs
 120 Apps
 48 News
 753 Onboarding
 1.2K 日本支部
 Private Company Board