0 Replies Latest reply: Mar 18, 2014 1:39 PM by Gayathri Nishtala RSS

    set analysis with if condition

      I want to create a set analysis for last month and current month in a bar chart, which has expression calculations as below

      Expression1:

       

      if([Type]='P' and match([DATE_FISCAL_MONTH_NUM_SHORT],3,6,9,12), SUM([indirect charges])/200,SUM([indirect chrges]/160)) as "in charges charges"

       

      Expression 2:

      if([Type]='D' and match([DATE_FISCAL_MONTH_NUM_SHORT],3,6,9,12), SUM([Direct  charges])/200,SUM([Direct  charges]/160)) as "direct  charges"

       

      set analysis calculation:

      total = direct charges+indirect charges