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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive