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?




      Rubens Rodrigues