Do you know the launch date?

If you have a launch date per product, you could make a calc like this:

IF [transaction date] >= [launch date] then [Value] END

And then you would use SUM([this new calc]) throughout the application  instead of doing SUM([Value]).  Because there is no ELSE in that calc, you'll get NULL for all values before the launch date.

That's OK.

IF [Product] = "my special product" then

   IF [transaction date] >= [launch date] then [Value] END

ELSE

  [Value]

END

HI Nancy

I hope this helps.

First of all, your "Week" is difficult to sort on the formula because string "Week 11" comes beyond "Week 2".

I converted week to below two digit format.

Then Assuming Design 2 is BETA until WW38,

Thanks,

Shin

Hi Nancy

Information is not enough.

Give me the first and last week ID of each quarter.

I am asking

17Q101~17Q113, 17Q201~17Q213  ~~~~  17Q413

or

17Q101~17Q113, 17Q214~17Q226  ~~~~ 17Q453

Shin

HI Nancy,

As long as the "week" part shows two digits like 01,02....  you can directly use this field in the formula.

I don't know when is the WW38, but assuming 17Q312, the formula should be like below.

//Design 2 Mod//

if [YYQ#WW] > "17Q312" then [Design 2] end

With given format, week is automatically judged "<",">" correctly in the formula..

(One digit , two digits combined format has a problem)

Regards,

Shin

Please attach failure workbook.

Shin

Try below if [Design 2} is already aggregated, but anyway, need to see the data.

//Design 2 Mod//

if attr([YYQ#WW] )> "17Q312" then [Design 2] end

Thanks,

Shin