Converting if to Set Analysis

[#1]

Dear Champs,

How can I convert the following if statement to set analysis.

Sum(if(DATE>=num(MonthStart('$(Variable)')) and DATE <=num(MonthENd('$(Variable)')) ,  AMOUNT))

Thanks in Advance

DERIK

[#2]

Dear,

Derik.

i think it's better if you create two variables

v1=Num(Monthstart(field))

v2=num(MonthEnd(field))

Expression:

SUM( {$<DATE = {">=$(#v1) <=$(#v2)"} >} AMOUNT)

Thanks,

Mukram.

[#3]

Thanks Mukram,

But I don't want to create a variable. Becoz I have 30expression, creating variable willl be tough.

DERIK

[#4]

Hi Derik,

Try the below Expression:

Sum ({<DATE  = {">=$(=Num(MonthStart(Min(FIELD))))<=$(=Num(MonthStart(Max(FIELD))))"}>}Amount)

Regards,

Desmortes

[somenathroy]

Try with this:

Sum( {< DATE = {' >= $(=Num(MonthStart("$(Variable)"))) <= $(=Num(MonthEnd("$(Variable)")))'} >} AMOUNT)

[MayilVahanan · Accepted solution]

Hi

    Try like this

    Sum ({<DATE  = {">=$(=MonthStart(Min(FIELD)))<=$(=MonthStart(Max(FIELD)))"}>}Amount)

Hope it helps