Show only 2024 costs

PJG
Member
in Beast Mode
My usual disclaimer: I am not a programmer, and usually need an ELI5 for this :)
I have a version of this code working that is intended to show the total PlannedCosts when summing the 5 FinancialCategoryName types I have listed. Basically the same thing without the YEAR(Month
,2024) AND piece. That works.
Now I'm trying to create a new version per below where it only shows the costs which occur in 2024, but it's still showing costs from all years. Can anyone help me understand why? Maybe I'm using the wrong function?
(sorry, don't know how to paste into the forum and keep the backticks)
CASE
WHEN YEAR(Month,2024) AND FinancialCategoryName='CAPEX - External IT Resource' THEN PlannedCost
WHEN YEAR(Month,2024) AND FinancialCategoryName='CAPEX - Internal IT Resource' THEN PlannedCost
WHEN YEAR(Month,2024) AND FinancialCategoryName='CAPEX - Hardware' THEN PlannedCost
WHEN YEAR(Month,2024) AND FinancialCategoryName='CAPEX - Software License' THEN PlannedCost
WHEN YEAR(Month,2024) AND FinancialCategoryName='CAPEX - Travel & Expense' THEN PlannedCost
END
My dataset has a column called Month with values formatted as Dec 1, 2025 12:00:00 AM.
0
Best Answer
Answers
-
Hi @MichelleH perfect, thank you!
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 745 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 67 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive