Sum of Specific Expense Type

I have 5 different Expense Category and want to bring the sum of a specific expense category. What should be the formula
Best Answer
-
Try
sum(case when
Parent Expense Category Name
= 'P-CARD' THENTransaction Amount
END)When working with pivot tables, I find it easier to re-structure the underlying dataset to get the desired pivot format. Beast modes can be a hit-or miss when the goal is to display a customized calculation in a pivot table.
0
Answers
-
Depending on what you are actually displaying, you could simply drag your expense category into the filters and filter to that specific category.
If you need to still show the other categories, you can create a beast mode that only sums that category like this:
SUM(CASE WHEN category = 'mycategory' THEN valuefield END)
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
CASE WHEN
Parent Expense Category Name
= 'P-CARD' THEN SUM(Transaction Amount
) END this formula gives me the sum at a total level. IN the pivot table I have the business segment and the function for which the individual values do not show up.So basically I want the expense category numbers total by Business function level too in the pivot.
0 -
Try
sum(case when
Parent Expense Category Name
= 'P-CARD' THENTransaction Amount
END)When working with pivot tables, I find it easier to re-structure the underlying dataset to get the desired pivot format. Beast modes can be a hit-or miss when the goal is to display a customized calculation in a pivot table.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 818 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 191 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 408 Distribute
- 116 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive