Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: summing a subtotal (GH2) derived from formula Post Reply Post New Topic
Author Message
althomas
Newbie
Newbie


Joined: 09 Nov 2010
Online Status: Offline
Posts: 36
Quote althomas Replybullet Topic: summing a subtotal (GH2) derived from formula
    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!!
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet 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.
IP IP Logged
Libby
Newbie
Newbie
Avatar

Joined: 16 Sep 2011
Online Status: Offline
Posts: 4
Quote Libby Replybullet 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? 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.023 seconds.