Wrong grand total
I have two columns 1) Actual Variance and 2) Absolute Variance.
Actual Absolute
2 2
-2 2
4 4
-3 3
Total 1 11I am getting the correct count 1 for the actual variance but for the absolute variance I am getting the same value as actual with the positive sign.I am using abs function to wrap the actual calculation for the absolute variance.How to derive the correct number for Absolute Variance?ThanksBest Answer
-
Assuming my direction is correct, you'll need to apply ABS() around your formula. Hard to say without all the details of the formula. You want to calculate the absolute value of the actual variance formula, not just the column, then sum it.
ABS(
Actual Value
-Budget Value
)If your data is grouped, you would need to sum up the variances for each group. And avoid nesting (one inside another). Are you doing this in an ETL or creating a formula on a card? (I prefer to do aggregates on an ETL before taking the data to a card.)
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
Sounds like the issue has to do with abs() being applied to the total sum instead of each individual variance value.
Calculate Absolute Variance Row by Row: Use the abs() function on each individual value in the "Actual Variance" column to get the absolute values row-by-row.Sum the Absolute Values: Once you have the absolute values calculated for each row, sum those values to get the total.
SUM(ABS(`Actual Variance`))
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
When I try to wrap it around with SUM it says there is a calculation error. I have a formula for Actual Variance it is not straight from the table
0 -
0
-
Assuming my direction is correct, you'll need to apply ABS() around your formula. Hard to say without all the details of the formula. You want to calculate the absolute value of the actual variance formula, not just the column, then sum it.
ABS(
Actual Value
-Budget Value
)If your data is grouped, you would need to sum up the variances for each group. And avoid nesting (one inside another). Are you doing this in an ETL or creating a formula on a card? (I prefer to do aggregates on an ETL before taking the data to a card.)
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 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
- 108 Community Announcements
- 4.8K Archive