Dan,
This should get the result you want.
tjlcost = (sum(lcost)) from bluebk where jobnum = .jnum
John
At 10:45 AM 1/25/2006, you wrote:
Hi All,
I am having a bit of trouble getting a variable assigned in a report.
I am using 6.5++ windows
I have a report with two breakpoints, first breakpoint is on EMP
(employee), and the second is on JOBNUM (jobnumber) if in the report I
assign an aggregate function to find the labor cost of a jobnumber it will
find it for just the total cost for that employee. I need that, but I also
need it for any employee that worked at that jobnumber.
The agregate function assigns the varaible :
SUM_OF_lcost = SUM OF lcost
(which only gets the total lcost for just the one employee being reported
on in that break.)
I need something like:
tjlcost = (sum) lcost from bluebk where jobnum = .jnum
but I can't seem to come up with the right syntax to type into the 'Edit
Variables (Define Expression)' box.
Any Ideas?
Dan Champion
www.championsolutions.net
616-299-7420
