converting if to set analysis

[#1]

sum(if(len([Actual FOUR Date])>0 and [Actual FOUR Date] >= date(MakeDate(2012,(vselectMonth),01)) and [Actual FOUR Date] <= date(MakeDate(2012,(vselectMonth),(vlastdate)))
and State='ANDHRA PRADESH'
,Order_In_MW))

Please help me out... change the above if condition to set analysis...

[manideep78]

Try this,

Sum({<[Actual FOUR Date]={">=$(=date(MakeDate(2012,(vselectMonth),01)))<=$(=date(MakeDate(2012,(vselectMonth),(vlastdate))))"},

            State={'ANDHRA PRADESH'}>}Order_In_MW)

[#3]

Hi

Try this

if(Len([Actual FOUR Date])>0,

Sum({<[Actual FOUR Date]={">=$(=MakeDate(2012,(vselectMonth),01))<=$(=MakeDate(2012,(vselectMonth),(vlastdate)))"},State={'ANDHRA PRADESH'}>}Order_In_MW),'')

Best of luck

[CELAMBARASAN]

No need to check the lenght of datefield here.

sum(if(len([Actual FOUR Date])>0 and [Actual FOUR Date] >= date(MakeDate(2012,(vselectMonth),01)) and [Actual FOUR Date] <= date(MakeDate(2012,(vselectMonth),(vlastdate)))

and State='ANDHRA PRADESH'

,Order_In_MW))

Simply use it as

Sum({<[Actual FOUR Date]={">=$(=date(MakeDate(2012,(vselectMonth),01)))<=$(=date(MakeDate(2012,(vselectMonth),(vlastdate))))"},State={'ANDHRA PRADESH'}>} Order_In_MW)

Hope it helps

Celambarasan