4 Replies Latest reply: Oct 5, 2011 9:08 AM by Michiel van de Goor RSS

    Set analysis, Sum({1} Sales/$(vExchangerate)), {1} doesn't work

    Michiel van de Goor


      I have this statement:

      =Sum ({1}Sales)/$(vExchangeRate)


      I expect this would return sales for all years (2005 - 2009) but it only returns sales for selected year.


      I also tried

      =Sum ({1}Sales/$(vExchangeRate))

      but this also returns only sales for selected year.


      Is my assumption correct that it should return all years?


      If not, should I create a date island?