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:
Thank you,
Monika
Answers
-
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.
Don't.
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
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive