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

      Hi,

      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?

       

      Thanks