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
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 95 Manage
- 92 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive