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),


      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?