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

    How can write same expression in Set Analysis.

    iTree Consulting

      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 Adhimulam

          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