Set Analysis Ignores 'Full Set' indicator when using intersections?

[#1]

I'm having a problem with an expression using set analysis with intersections.  It seems to ignore the '1' at the beginning of the set statement that should make it ignore any selections made.  I tried putting a 1 at the beginning of each set statement, but the value still changes any time i make a selection.  Here's an example of the syntax I'm trying to use:

Count({1<SF_DATE = {'>$(=date(v90DaysPast))'}>*1< SF_DATE = {">$(=min(CAMP_START_DT))=$(=min(PROMO_RESP_WINDOW))"}>*1<SALES_FUNNEL_PHASE = {'SALE'}>} UNIQUEID)

Maybe i'm just missing a character somewhere?

[swuehl]

Ashley,

your dollar sign expansions are probably affected by user selections, for example the min() functions.

You can add a set identifer {1} also to the min() function.

Variable v90DaysPast should also be checked.

Besides that, hard to help you without knowing your data, model, requirements...

[Gysbert_Wassenaar]

< SF_DATE = {">$(=min(CAMP_START_DT))=$(=min(PROMO_RESP_WINDOW))"}>

This doesn't look quite right. Is there a < character missing before the = character in front of $(=min(PROMO_RESP_WINDOW))? Or is PROMO_RESP_WINDOW a number of days that should be added to or subtracted from the date returned by min(CAMP_START_DT)?