Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm certain I've come across this before but am unable to find it again. I have a count using set analysis in a date range, but I'm wanting to increase the date variables by a defined number of days. For the sake of this example I'll say by 30 days. Here's the statement I currently have:
=COUNT(
{$
<COUNT_DATE={">=$(vStartDate)<=$(vEndDate)"},REAL_PLAY_COUNT={1}>
}
distinct PARTY_ID)
Thanks in advance
Grant
=count({<COUNT_DATE={">=$(vStartDate)<=$(=Date(30+(vEndDate)))"},REAL_PLAY_COUNT={1}>} distinct PARTY_ID)
Hi,
This One?
COUNT(
{$
<COUNT_DATE={">=$(vStartDate)<=$(=vEndDate+30)"},REAL_PLAY_COUNT={1}>
}
distinct PARTY_ID)
=count({<COUNT_DATE={">=$(vStartDate)<=$(=Date(30+(vEndDate)))"},REAL_PLAY_COUNT={1}>} distinct PARTY_ID)
sorry for the delay in responding guys, thanks for the quick answers. I lost access to the data for a few days. I'm checking those now.
Thanks guys! I used Maxgro's solution but they both worked