i am having troupble with the syntax for the following formula..

 

If Month(currentdate) >11
then MONTH({CASE_VOLUME\\.MSDATE}) = Month(currentdate)-11 and Year({CASE_VOLUME\\.MSDATE})= year(currentdate)+1
 Then {PART_PRICE_COST_SET\\.UNIT_COST_CS1}*{CASE_VOLUME\\.FORECAST_CASE_QTY}*{RECIPE_BREAKDOWN_4B\\.QTY}
else
IF MONTH({CASE_VOLUME\\.MSDATE}) =  Month(currentdate)+1
THEN {PART_PRICE_COST_SET\\.UNIT_COST_CS1}*{CASE_VOLUME\\.FORECAST_CASE_QTY}*{RECIPE_BREAKDOWN_4B\\.QTY}
ELSE 0

 

Is there an obvious error I am missing??

how do you get the 2nd 'then' included?

 

thanks

the previous report works OK

IF MONTH({CASE_VOLUME\\.MSDATE}) =  1
THEN {PART_PRICE_COST_SET\\.UNIT_COST_CS1}*{CASE_VOLUME\\.FORECAST_CASE_QTY}*{RECIPE_BREAKDOWN_4B\\.QTY}
ELSE 0

 

 as long as I restrict the selection to the current year or next year using select expert

 

but now a rolling 12 months is required and when the month goes into the new year I get forecast results from JAN 2011  AND  Jan 2012!

 

The error I get is " the remaining test does not appear to be part of the formula"   and the text after "year(currentdate)+1 " is highlighted.

 

Sorry if this is not clear - my brain is a bit scrambled at the mo!!

 

Thanks

 

 

I have had a play and I think I can get the results I want but I am struggling with the format/layout...

the user would like the report to display

component part          this month       next month     month after   etc...

 

 

another idea was somthing like 

IF Month({CASE_VOLUME\\.MSDATE})= month (dateadd('m',+1,((currentdate))))
THEN {PART_PRICE_COST_SET\\.UNIT_COST_CS1}*{CASE_VOLUME\\.FORECAST_CASE_QTY}*{RECIPE_BREAKDOWN_4B\\.QTY}
ELSE 0

 

but - does the date add take into account the year?  so when it date add 1 month onto december 2011 it then looks at jan 2012?

 

i am about to try it in another report so will post the results here a bit later!

Cheers

 

report doing exactly what I wanted!!

Many Thanks.