I want to build a report

TABLE FILE VIP_BEL_MUTATIE
PRINT
BUYSELL
NUMBERSTOCKS
COMPUTE MUT/D13.4 = IF BUYSELL EQ 'B' THEN NUMBERSTOCKS ELSE -1 * NUMBERSTOCKS;
COMPUTE SALDO/D13.4 = SALDO + MUT; WITHIN STOCKID
BY CLIENTCODE
BY STOCKID
BY DATEFIELD
END

The result should give me
by each CLIENTCODE an overview of the bought and sold stocks and the calculated running sum per stockID

If I run this report the calculated running sum does not start on each new STOCKID or CLIENTCODE.

What is wrong her?

quote:

COMPUTE MUT/D13.4 = IF BUYSELL EQ 'B' THEN NUMBERSTOCKS ELSE -1 * NUMBERSTOCKS;
COMPUTE SALDO/D13.4 = SALDO + MUT; WITHIN STOCKID
BY CLIENTCODE
BY STOCKID

I'd change the second compute to say,

IF CLIENTCODE EQ LAST CLIENTCODE THEN SALDO + MUT ELSE MUT;

Hi Frank,

Can you please try this code:

TABLE FILE CAR
SUM  
     BODYTYPE   
     SALES   
COMPUTE SALRT/D12.2 = IF  (CAR EQ LAST CAR) AND ( COUNTRY EQ LAST COUNTRY) 
 THEN SALES + SALRT ELSE SALES;
BY COUNTRY
BY CAR
BY MODEL
END

Hope this helps.

Cheers,

Kerry

Yes this is great.
thanks for the solution!