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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 83 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive