row total is not correct
I am working to create a Pivot table, where Year_Budget column is the average amt and Actual Amt is the the aggregrate.
There are two questions, the subtotal of Year_Budget is not correct, it should be 6195907.00, however is it displayed as 476608.23.
Also when I try to create a difference in value in BeastMode, I get a syntax error:
if i had to bet, i'm putting money on the fact that you JOINED the budget onto the Transaction Fact, and that's why you're using the Average.
Use a UNION to append the budget rows to your dataset. That way you can avoid having to use Avg.
See my tutorial video:
Re, your beast mode, remove the = sign. Use MySQL syntax.
Re, analyzer giving the 'wrong math', challenge your assumption. Why do you think the average should be <your number>?
If the annual budget for that GL Account is Joined to each transaction as I suspect, then you can't assume that your outcome will be a neat summation of the AVGs. That's not how AVG works. AVG would be the average of the amount across all transaction rows OR the avg, of the aggregated amount for each GL Account_Description. // either way, using average will not yield consistent or desired results.Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Your beast mode is giving an error because you have an equals sign at the beginning of it. Remove that and it should return as valid.**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
- 7.6K All Categories
- 917 Connectors
- 242 Workbench
- 472 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 31 Visualize
- 197 Beast Mode
- 2K Charting
- 7 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 19 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部