Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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