3 Replies Latest reply: Apr 4, 2012 1:39 PM by Sean Smith RSS

    Set Analysis Question

      Hello Again,

      I am having some difficulty with this set analysis.  It seems to work when I choose other date dimensions like Fiscal Year, YTD, Quarter to date but when I just try and use Date it is not working.
      So, why does this expression work:

      =sum({<Date={'4/4/2012'}>}[In company code currency_HSL]*-1*RatetoUSD)

       

      And the one I need to work below does not:

      =sum({<Date={$(max (Date)) }>}[In company code currency_HSL]*-1*RatetoUSD)

       

      Thanks again