count with accross

[Ericordina]

I have also an other problem (sample from empdata)

If i have an collumn salary and thats accrossed by year

How is then possible to generete an formule wich
can count the salary of year minus salary-1 /salary of year *100

 

[focwizard]

To get relationships between columns, when using an ACROSS, you can add a COMPUTE as a verb object. Then you reference the prior column by using the LAST operator (make SURE that the field which determines the 'last' value is the last sort field (in your example, that would be YEAR). The COMPUTE logic should check for a change in higher sort fields. Here's an example, using the CAR file:

TABLE FILE CAR
SUM SEATS
COMPUTE PCTDIFF/F6.2=IF BODYTYPE NE LAST BODYTYPE THEN 0
                     ELSE (LAST SEATS/SEATS) * 100;
BY BODYTYPE ACROSS COUNTRY
END

In this example, I compare values of higher sort fields (here 'BODYTYPE'), so I don't compare values for different COUNTRY values.

 

[Ericordina]

Thanx that is indeed the solution