Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to count distinct records that fall within a date range.
So, I have the following 3 variables:
I can calculate 'Days To Open' with the formula ([Opening Date]-Today()), and since some PS#'s have already opened, the "Days To Open' field can be a negative number.
What I want to do is count the number of unopened "PS#" that will open within the next 30 days. That is, 'Days To Open' is greater than 0, but less than 31.
What is the proper Count function expression to do this?
Thanks!
May be like this:
Count(DISTINCT {<[PS#] = {"=[Opening Date]-Today() > 0 and [Opening Date]-Today() < 31"}>} [PS#])
May be like this:
Count(DISTINCT {<[PS#] = {"=[Opening Date]-Today() > 0 and [Opening Date]-Today() < 31"}>} [PS#])
Thanks, Sunni. This worked perfectly! The syntax requirements for these formulas are so difficult for me.