if datediif('month',[sign up date],today())>3 then [User ID] end
and do a countd on this?
Thanks for the reply Alex.
That won't quite do it unfortunately. I probably did a poor job of explaining my problem.
I can't use today() and a fixed integer because I actually need this calculation to happen at every month.
Basically, imagine you have a data set of 12 months.
- filter out all of the months except January. Take the countd on that. This is the value for January.
- Next bring in February and take the countd on both of them. This is the value for February.
- Same with March, and so on...
In this way, since the previous months are included as well, only new, non-redundant members will be added to the countd at every month.
I just have no idea how to implement this. Like I said, perhaps there's another way entirely to get what I want as well.
I appreciate the help,
Does your data contain a user ID that is unique per user? I've done something similar to this for a project here at work. I'd need to find the workbook, but it involved counting the number of months per user ID and then comparing the current month's count (always 1) with the table calc count of all months for that user ID. If the table calc count was 1 and the current month's count was also 1, then that user ID was unique to that month.