1 Reply Latest reply on Dec 2, 2016 3:14 AM by Norbert Maijoor

    Calculation "case" formula

    Dilyana Suleymanova

      Hi guys,

      I have three calculation sheets:

       

      I want to do follow calculation:

       

      The numbers from May till August devided by sum of WDEX from the sheet " old target"

      and

      The numbers from September till December devided by sum of WDEX from the sheet " new target"

       

      I worked with the case formula:

       

      case MONTH([Date])

      when 5 then [#Numbers]/SUM([old target (Calculation sum devided by sum)].[Anzahl der Datensätze])

      when 6 then [#Numbers]/SUM([old target (Calculation sum devided by sum)].[Anzahl der Datensätze])

      when 7 then [#Numbers]/SUM([old target (Calculation sum devided by sum)].[Anzahl der Datensätze])

      when 8 then [#Numbers]/SUM([Calculation sum devided by sum].[Anzahl der Datensätze])

      when 9 then [#Numbers]/SUM([Calculation sum devided by sum].[Anzahl der Datensätze])

      when 10  then  [#Numbers]/SUM([Calculation sum devided by sum].[Anzahl der Datensätze])

      END

       

      see the field "Calculation" in my workbook

       

      Any ideas?