How can write same expression in Set Analysis.

[sona_sa]

Hi Friends,

Please suggest, how we can write the same expression in SET ANALYSIS.

Num(if(len(Master_Year)>0 and len([Month Only])=0, Sum( if(Comm_Year=vMaxMasterYear, Order_In_MW1)),if(len(Master_Year)>0 and len([Month Only])>0, Sum( if(Comm_Year=vMaxMasterYear and Actual_Comm_Month_No =vmaxMasterMonthNo, Order_In_MW1)),if(len(Master_Year)=0 and len([Month Only])=0, Sum( if(Comm_Year<=vMaxMasterYear, Order_In_MW1))))),'#,##0')

Regards,

AKumar

[CELAMBARASAN]

Hi,

     Check with this

     =Num(RangeSum(Sum({<Master_Year={*},[Month Only]-={*},Comm_Year={$(vMaxMasterYear)}>} Order_In_MW1),     Sum({<Master_Year-={*},[Month Only]={*},Comm_Year={$(vMaxMasterYear)},

Actual_Comm_Month_No ={$(vmaxMasterMonthNo)}>} Order_In_MW1),Sum({<Master_Year-={*},[Month Only]-={*},Comm_Year={"<=$(vMaxMasterYear)"}>} Order_In_MW1)),'#,##0')

Celambarasan