Print Page | Close Window

summing a subtotal (GH2) derived from formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12922
Printed Date: 27 Apr 2024 at 10:41am


Topic: summing a subtotal (GH2) derived from formula
Posted By: althomas
Subject: summing a subtotal (GH2) derived from formula
Date Posted: 14 Apr 2011 at 5:48am
Hi,
 I created a payroll summary to by first getting all labor hrs by employee and then date.
then i create a formula to seperate Regular time, Overtime, vacation
 
Now i need to subtotal the formulas i created (regular, overtime, vacation) but i cant summarize them when trying to yse the sum function. Is their another way?
The way it sorted is by Employee and all dates below and hrs worked breaken apart as regular, overtime, vacation) by using formula. i need to subtotal each category for each employee.
 
GH1 = Employee Name
   GH2 =  Payroll Date       Regular time,  Overtime, Vacation
GF1 =  Employee Total-need subtotal ????  ????        ???? 
 
Any help is greatly appreciated!!


Replies:
Posted By: lockwelle
Date Posted: 31 May 2011 at 3:22am
use shared variables and add them up yourself, you might be able to use running totals, but that isn't my forte.
 
You can't use an aggregate function on values that are not intrinsic to the data, which means if you created a formula that manipulates the data and extracts values, that an aggregate function like SUM() won't be available to summarize the results.

Posted By: comatt1
Date Posted: 06 Jun 2011 at 9:48am
I may be missing something, but if you set the EVALUATE to formula and put the logic within there, the sum will work. It actually should be pretty easy if I understand your intentions correctly.

Posted By: Libby
Date Posted: 20 Sep 2011 at 5:08pm
I am interested in getting help with the same issue.  Can you be specific about how you would correct the Newbie's problem? 


Print Page | Close Window