0 Replies Latest reply: Jun 10, 2013 12:33 AM by basil marotical RSS

    Converting to Set Analysis

    basil marotical

      Hi All,

       

      Please do help me to convert the below formulae to a more simpler set analsysis form :

       

      num(

      count(DISTINCT

              if(GetFieldSelections(vfiltertype)='filter1',if([date1]>=monthstart and [date1]<=selectedDate and [flag1]='1',[key]),

              if(GetFieldSelections(vfiltertype)='filter2',if([date1]>=yearStart and [date1]<=selectedDate and [flag1]='1',[key]),

              if(GetFieldSelections(vfiltertype)='filter3',if([date1]>=yearStart and [date1]<=yearEnd and [flag1]='1',[key]),

              if([year1]=year(date2) and [flag1]='1' and [flag2]='0' and [flag3]='0'

              and ([status]='status1' or [status]='status2'),[key])))))+

      count(DISTINCT

              if(GetFieldSelections(vfiltertype)='filter1',if([date3]>=monthstart and [date3]<=selectedDate and [flag2]='1',[key]),

              if(GetFieldSelections(vfiltertype)='filter2',if([date3]>=yearStart and [date3]<=selectedDate and [flag2]='1',[key]),

              if(GetFieldSelections(vfiltertype)='filter3',if([date3]>=yearStart and [date3]<=yearEnd and [flag2]='1',[key]),

              if([date4]=year(date2) and [flag2]='1',[key])))))+

              count(DISTINCT

              if(GetFieldSelections(vfiltertype)='filter1',if([date5]>=monthstart and [date5]<=selectedDate and [flag3]='1',[key]),

              if(GetFieldSelections(vfiltertype)='filter2',if([date5]>=yearStart and [date5]<=selectedDate and [flag3]='1',[key]),

              if(GetFieldSelections(vfiltertype)='filter3',if([date5]>=yearStart and [date5]<=yearEnd and [flag3]='1',[key]),

              if([date6]=year(date2) and [flag3]='1',[key])))))

          ,'#,##0')

       

      Thanks in advance.

      Brooklyn