help with set anlysis

[cspindley]

i am trying to use a var within set analysis but with the > operator rather than the = operator

can anyone help with this ?

[cspindley]

=count( {$< InTheMoney = {0,1} , ResponseW8 = {" >= $(=num(86400*vMinResponse)) <= $(=num(86400*vMaxResponse)) "} >} ResponseW8)

stil struggling, any ideas?

[cspindley]

=count( {$< InTheMoney = {0,1} , ResponseW8 = {" >= $(=num(86400*vMinResponse)) <= $(=num(86400*vMaxResponse)) "} >} ResponseW8)

still struggling ...

[cspindley]

=count( {$< InTheMoney = {0,1} , ResponseW8 = {" >= num(86400) "} >} ResponseW8 )

even the above simpler ver does not work

[cspindley]

=count( {$< InTheMoney = {0,1} , ResponseW8 = {" >= num(86400) "} >} ResponseW8 )

this not working either

[sasiparupudi1]

count( {$< InTheMoney = {0,1} , ResponseW8 = {">=86400"} >} ResponseW8 )

[sasiparupudi1]

What are the expressons in your variables

[blunckc1]

This is a set analysis formula I use to calculate the last 12 months only.

ENTERTHEAGGREGATION({<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=>} ENTERTHEFIELD)

Variables isloaded as follows

=if(isnull(GetFieldSelections(CalendarMonthYear)),date(today(),'MMM-YYYY'),date(max(CalendarMonthYear),'MMM-YYYY'))

[blunckc1]

???

It is rather annoying getting a blank message.