To further explain, anything that starts with a dash is considered Dialogue Manager and you should be testing against amper variables, not real fields and njsden is correct in that LAST won't work there.

If your IF test is in a DEFINE or COMPUTE, then it must be on the right-hand side of an equal sign, i.e.

FIELDNAME/format=IF ...;  

Does this make sense?

quote:

Originally posted by TexasStingray:
Please post a little more code. to give every one a better understnading

I would like my report to print a short description instead of the long one of the profit center column on each breakdown .
------------------------------------------
-DEFAULTS &APCDESC = 'ABC';
....

TABLE FILE T3Y_SLSWKBGT
-IF PROFITCENT NE LAST PROFITCENT THEN &APCDESC = DECODE PROFITCENT ( 001 'MTL' 401 'QUE' 150 'BOO' 200 'DES' 300 'ALM' 500 'HUO' 100 'BAR' 600 'MUE') ELSE FOC_NONE;
SUM
CURSALES/P12C AS 'RÉEL(R),ACTUEL'
COMPUTE CPSLSCUM/D12 = IF PRFCENTDSC EQ LAST PRFCENTDSC THEN CPSLSCUM + CURSALES ELSE CURSALES; AS '***.'

.....
-*BY PRFCENTDSC AS 'Centre,Profit'
BY &APCDESC AS 'Ctr,Pft'
BY PERIODWK AS 'Sem.'
BY NBRWDYWK AS '#Jrs'
HEADING
"&TITLE_1"
....


I can provide more, just tell me.

Is 'ABC' a column name in T3Y_SLSWKBGT? I'm asking this because you have a BY phrase which will evaluate to 'BY ABC AS ...".

Is PROFITCENT a column name as well?

If I could take a guess, I'd say that it needs to look like this:

DEFINE FILE T3Y_SLSWKBGT
APCDESC/A3=DECODE PROFITCENT ( 001 'MTL' 401 'QUE' 150 'BOO' 200 'DES' 300 'ALM' 500 'HUO' 100 'BAR' 600 'MUE') ELSE ' ';
END
TABLE FILE T3Y_SLSWKBGT
SUM
CURSALES/P12C AS 'RÉEL(R),ACTUEL'
COMPUTE CPSLSCUM/D12 = IF PRFCENTDSC EQ LAST PRFCENTDSC THEN CPSLSCUM + CURSALES ELSE CURSALES; AS '***.'

.....
-*BY PRFCENTDSC AS 'Centre,Profit'
BY APCDESC AS 'Ctr,Pft'
BY PERIODWK AS 'Sem.'
BY NBRWDYWK AS '#Jrs'
HEADING
"&TITLE_1"
....

How does that look to you? Does it make sense?

You got it right Ginny. Thanks alot. It works. That will enthusiamed me to continue using forums. This can be considered as closed.

quote:

Originally posted by GinnyJakes:
Is 'ABC' a column name in T3Y_SLSWKBGT? I'm asking this because you have a BY phrase which will evaluate to 'BY ABC AS ...".

Is PROFITCENT a column name as well?

If I could take a guess, I'd say that it needs to look like this:

DEFINE FILE T3Y_SLSWKBGT
APCDESC/A3=DECODE PROFITCENT ( 001 'MTL' 401 'QUE' 150 'BOO' 200 'DES' 300 'ALM' 500 'HUO' 100 'BAR' 600 'MUE') ELSE ' ';
END
TABLE FILE T3Y_SLSWKBGT
SUM
CURSALES/P12C AS 'RÉEL(R),ACTUEL'
COMPUTE CPSLSCUM/D12 = IF PRFCENTDSC EQ LAST PRFCENTDSC THEN CPSLSCUM + CURSALES ELSE CURSALES; AS '***.'

.....
-*BY PRFCENTDSC AS 'Centre,Profit'
BY APCDESC AS 'Ctr,Pft'
BY PERIODWK AS 'Sem.'
BY NBRWDYWK AS '#Jrs'
HEADING
"&TITLE_1"
....

How does that look to you? Does it make sense?