7 Replies Latest reply: Jul 3, 2015 4:28 PM by Rubens Rodrigues RSS

    SET ANALYSIS = Using MAX(DATE) and disregard YEAR, MONTH and DAY Selection

    Rubens Rodrigues

      Hi folks,

       

      I have the following scenario:

       

      I'm trying to sum a VALUE considering only the values accumulated in the MAX DATE of my fact table. It's currently working through the expression bellow:

       

      SUM( {$< TYPE_FACT = {'Remove CAP'},  DATE = {'$(=Max(DATE))'} >} VALUE )

       

      However, the expression is currently considering the YEAR, MONTH and DAY selected in order to set the MAX(DATE), but I don't want it to consider those filters.

       

      What can I do in this case?

       

      Cheers,

       

      Rubens Rodrigues