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
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 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