Filter Rule Needed

[krobert1]

Hello!

Looking for a filtering rule to accomplish the following :

Do not include in results if "Customer" had "type a membership" in "closed date of membership"> 6months from current date

TYIA!

Sent from my SM-G920P using Tapatalk

[bdbits]

Please read http://www.cognoise.com/index.php/topic,24030.0.html in particular item 1.

Also read the Report Studio user guide (accessible under the help menu in RS).

[krobert1]

Hello! I see no one has had the opportunity to assist me in figuring this one out. I have tried to put in what I think would be right, but no such luck. Perhaps this layout will assist readers in telling me what I am doing wrong with these?? Any help at all would be very helpful, as I am entirely new to these formats. . . I am not in Excel anymore. . lol

case
when [Closed_date] >= _add_months( current_date,-6 )
then [customer_#] in ( [countofcustomers] )
else [customer_#] not in ( [countofcustomers] )
end

TYIA

[bus_pass_man]

Oh I had the opportunity but went to Loblaws instead.

...and yes, you're not in Excel. Approaching the problem using an Excel-centric perspective will be a surefire way to headaches.

Please read http://www.cognoise.com/index.php/topic,24030.0.html in particular item 1.

You don't say what happened when you tried the expression which you wrote. I'm not the amazing Kreskin.  Where did you try the expression? What results did you get?  Did you get an error?  If so, what is the error message saying?  If you didn't get an error but values what can you infer from those values?

A filter returns a boolean.  The expression which you have is not a filter.  Part of it would be a valid filter expression and might be what you want.  You do have the basic idea about what the filter expression you want, which is good.

Get stuck in; the intellectual exercise is inherently useful.

Hope that helps.