OK here is my problem: Report ha

[strom99]

OK here is my problem:

Report has multiple groupings, one is by a field called GLBL_SLS_CODE for this field I need to find a way to put in a forecast number. I have tried this

IF {VGEDW_prod_hrcy_dim_usa_10.GLBL_SLS_CODE} = 'PBL' THEN 650000

I can do that for 25 of them easy, but each month has a different forecast, how can I make the formula say "IF [GLBL_SLS_CODE} = 'PBL' AND @FIRSTDAY THIS MONTH IS InMonthToDate Then 650000. Does this make sense.

The @FIRSTDAY THIS MONTH is a formula field.

Using CR8

 

[kenhamady]

You were close, the following is a valid formula:

IF [GLBL_SLS_CODE}= 'PBL'
AND
{@FIRSTDAY THIS MONTH} In MonthToDate
Then 650000
else 0


Look at the date range functions and you will see about 25 different ranges. They all are used as above with the word IN. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)