Jump to content

Number Scripting


This topic is 7782 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a script which searches for an employee and a date range (the work week). This script also sorts that found set and has a sub-summary which sub-totals the total number of hours worked by day for the found employee. I am having a tough time trying to figure out how to add additional calculations once that sub-total for each day is found. These employees are paid on a per-day overtime basis. I am able to extract this information and perform these calculations to another database which just show totals but I would like to have this done in the original database. Is there a way to calculate the per day overtime charges and show them in the same area as the sub-total?

Link to comment
Share on other sites

As a matter of fact I have and it works somewhat.... I am still trying to figure out how to get the summary to show and print in the preview mode without inserting that data into every record in the sub-set and to total in a grand summary area.

Is there a way to go to the last record in each sub-set and populate that record with the GetSummary data? smile.gif" border="0

Link to comment
Share on other sites

quote:

Originally posted by stac_1:

Is there a way to go to the last record in each sub-set and populate that record with the GetSummary data?
smile.gif" border="0

Sure, just answer this question: What is the last record in each subset and what fields will be used to store the get summary data?

Link to comment
Share on other sites

Okay, the last record in the sub-set is the highest serial number (because I sort each record in the whole found set by serial number) - the field is used to hold the Get Summary information is a field called "straight"... by using the getsummary function, I am able to get the summary of a sub-set.... what function is used to enter this data in the last record of the sub-set?

Insert Calculated result inserts the data in the current record, how do I get to the last record of the sub-set?

[ April 24, 2001: Message edited by: stac_1 ]

Link to comment
Share on other sites

This topic is 7782 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.