Can i Sum the value in a set of data based on the max date selected in the date filter
I have a set of data which is a snap shot of records each month. I want to Sum one column only where the date is equal to the latest date selected using the date filter in the chart. I tried the formula below but it is giving me no output.
SUM(CASE WHEN `ACV Fiscal Month`= MAX(`ACV Fiscal Month`) then `ARR Amount(USD)`else 0 end)
The Max formula works on it's own but it doesn't seem to like being compared to in the when statement..
Many Thanks in advance for any help!
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 754 Onboarding
- 1.2K 日本支部
- Private Company Board