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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive