12 Replies Latest reply: Apr 1, 2015 5:24 AM by Denis Windisch RSS

    How to use multiple selected months for calculating measures

      Hey there,

       

      I have a master calender and it is already possbile to select multiple months.

      I also get the values with the GetFieldSelections() function. (output e.g: Jan,Feb,Mrz...)

       

      But when I want to calculate different measues it is only working with one selected month.

       

      My expression for calculating Retail Sales:

       

      if(isNull(MasterMonth), SUM({<Year_RS=MasterYear>}Retail_Sales),
      SUM({<Year_RS=MasterYear,Month_RS=MasterMonth>}Retail_Sales))

       

      Its working very well if only one month is selected but if there are multiple months the result is always the total of the selected year.

       

      I think its because of the isnull(MasterMonth) but I don't know how to solve it

       

      Any ideas?