topic How can write same expression in Set Analysis. in Water Cooler

How can write same expression in Set Analysis.

sona_sa — Thu, 05 Apr 2012 06:19:56 GMT

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

How can write same expression in Set Analysis.

CELAMBARASAN — Thu, 05 Apr 2012 08:44:00 GMT

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