1 Reply Latest reply: Mar 3, 2015 11:50 AM by Rupert Cavendish RSS

    Calender and Switch between Sales and turnover

    Andreas Felderhoff

       

      I try to get a evaluation table, where I can switch between turnover (€) and sales volume (pcs). If one month is selected on the calendar, the value (turnover or sales volume) should be calculated YTD of the selected month. If several months are selected, the value should contains the selected months. The whole should be performant possible. The following formula works only with the function to switch between turnover and sales and select one month. Unfortunately this solution makes QV very slow:

       

       

       

      SUM
      (
      if (GetSelectedCount (MONTHCALENDER) =1,
      (
      if(InYeartoDate(DATE, MONTHCALENDER, 0), (If (VARIABLE = 'TURNOVER',S_TURNOVER,if (VARIABLE = 'SALES' ,S_SALES))))),
      (
      If (VARIABLE = 'TURNOVER',S_TURNOVER,if (VARIABLE = 'SALES' ,S_SALES)))))

       

       

       

      MONTHCALENDER:

       

       

      30.11.2014

       

      31.12.2014

       

      31.01.2015

       

      28.02.2015

       

      31.03.2015

       

      30.04.2015

       

       

       

       

      VARIABLE:

       

      SALES

       

      TURNOVER

       

       

       

       

       

      Month

      Variable

       

      Month

      Variable

      Jan

      20

       

      Jan

      20

      Feb

      25

       

      Feb

      25

      Mrz

      22

       

      Mrz

      22

      Apr

      30

       

      Apr

      30

      May

      35

       

      May

      35

      Jun

      31

       

      Jun

      31

      Jul

      28

       

      Jul

      28

      Aug

      34

       

      Aug

      34

      Sep

      26

       

      Sep

      26

      Oct

      25

       

      Oct

      25

      Nov

      48

       

      Nov

      48

      Dez

      14

       

      Dez

      14