REPORT CALCULATIONS

[gscma1]

I HAVE REPORT WHICH PRINTS OFF THE DETAILS OF EACH EMPLOYEES GROSS WAGES PER WEEK BY THE AMOUNT OF HOURS THEY WORKED AT EACH INDIVIDUAL JOB: I.E.

JOE BLOGGS
WK 1 £100 JOB 1
WK 1 £90 JOB 2
WK 2 £330 JOB 1
ETC...

IS IT POSSIBLE TO HAVE FORMULA WORK OUT THE TOTAL WAGES FOR A SPECIFIC WEEK I.E.

JOE BLOGGS
WK 1 £100 JOB 1
WK 1 £90 JOB 2
WK 1 TOTAL £190
ETC...

MANY THANKS ANY HELP WOULD BE APPRECIATED

 

[TISIBS]

You can solve this in your select statement. Add the following to the select clause:
SELECT SUM(wages) OVER PARTITION BY (week) AS sum_per_week
or you can do it with a summary column:
Function: Sum
Source: wages
Reset at: Group of the week

Hope it helps
Timo