3 Replies Latest reply: Sep 23, 2009 4:34 PM by Mark McCoid RSS

    Set Analysis using other fields

      HI

       

      I am trying to calculate the impact of a new product launch. A new product is only new for so long so need to use set analysis to restrict the date range.

      Alongside each sales line I have the launch date for the product.

       

      so in theory the set analysis should look something like this

       

       

      sum(

      {

      <

      [ShipDate]={">=LaunchDate <([LaunchDate]+35)"}

      >

      }

      Quantity) however if I use this I get no results if I discreetly enter the dates I get the correct answer as below



       

       

      sum(

      {

      <

      [ShipDate]={">=LaunchDate <([LaunchDate]+35)"}

      >

      }

      Quantity)



       

      I have attached an example - am I just doing something wrong with the syntax for using the launchdate?

       

      Thanks

       

      Matt