Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Basically, I only want to SUM the $$ [Upsell ARR (converted)] if the Close Date of an Opp is > the start of a campaign. I feel like I have the right syntax below but it isnt working. Maybe I am overlooking something. Any help is appreciated.
Sum({<[Close Date] = {'>[Campaign Start Date]'}>}[Upsell ARR (converted)])
-dave
May be this:
Sum(If([Close Date] > [Campaign Start Date], [Upsell ARR (converted)]))
Is your Close Date and Campaign Start Date, holds same date formatting?
May be this:
Sum(If([Close Date] > [Campaign Start Date], [Upsell ARR (converted)]))
This worked thank you Sunny
A even better approach here would be to create a flag in the script
LOAD If([Close Date] > [Campaign Start Date], 1, 0) as Flag
and then this
Sum({<Flag = {1}>} [Upsell ARR (converted)])
Campaign Start Date and Close Dates aren't static so they need to be calculated per user selections, but thank you for the tip!!!