Set Analysis using other fields

[#1]

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

[#2]

Hi Matt,

where are your example???

Rainer

[#3]

Sorry Attachment should now be there

Matt

[markmccoid · Accepted solution]

Hi, You need to use $ expansion on the dates:

sum({<[ShipDate]={">=$(=LaunchDate) <$(=date(([LaunchDate]+35)))"}>}Quantity)