0 Replies Latest reply: Jul 23, 2013 11:23 AM by kewin833 RSS

    Force month of a complex variable

      Hello,

      I would first like to congratulate you for the splendid forum and professionalism.

       

      I have a complex variable, with sums and if inside, I wanted to know how to force the date since this classic with set analysis is not taken,

       

       

      For example:

       

      Variable:

       

      $v_sales = if ((cal_yyyy) = Year (Today ()) -1, sum($(sales_ytd), count($(sales_y))

      /

      if ((cal_yyyy) = Year (Today ()) -1, count ($(contra_ytd), count($(contra_y))

       

       

      Set Analysis:

       

      = sum( {< Month={'JAN'} >} $v_Sales)

       

      in this example, when I select a month I only ever returns the sum of the month, if you select more months, the sum is accumulated,

      what I want is to set the sum to one month of the variable,possibly ignoring other selections or more selections.

       

      Thank you very much, and I apologize for my bad English.