Calculated field for before and after date
I have a calculation based on date that is only half working.
CASE WHEN (DATE(Date
)<'03/01/2024') THEN SS Revenue
ELSE (SS Impressions
*eCPM
/1000) end
In the formula, it is pulling in the correct amount when it is BEFORE 3/1/2024, but for some reason, it is returning 0 for anything after that date. When I look at the SS Impressions and eCPM, those calculations are correct and showing the correct information.
I am not sure what is missing.
Any thoughts?
Answers
-
I know what the issue is. The eCPM is calculated on based on rows labeled GAM and therefore the eCPM only shows in GAM rows and SS Rows are then left blank for eCPM. I need the eCPM to show in ALL rows. The calculation for eCPM is (SUM(CASE WHEN
Ad Server
= 'GAM' THENRevenue
END) / SUM(CASE WHENAd Server
= 'GAM' THENImps
END)) * 10000
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 574 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 355 Distribute
- 94 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive