1 Reply Latest reply: Apr 5, 2012 4:44 AM by Celambarasan Adhimulam

# How can write same expression in Set Analysis.

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.

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