Calculated field for before and after date

s_f_OTT · 2024-04-11T21:28:08+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Beast Mode

Accepted answers

All comments

s_f_OTT

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' THEN Revenue END) / SUM(CASE WHEN Ad Server = 'GAM' THEN Imps END)) * 1000

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of