# Job Progress Report Calcs

Maybe I don't understand what your asking. Are you asking if
changing the date 01/07/2001 is necessary? Shouldn't be. 01/07/2001
is a base week beginning date that should be OK from now on.

Am I missing your point?

Lonnie

--- In vantage@y..., "Wendy Bowen" <wpursche@s...> wrote:
> #2 worked perfectly!
>
> But for #1 is there a way I can say take "Monday - Sunday" labor
hours on that job without giving an exact date, just inputting the
words "Monday, Sunday"? That way I wouldn't have to go in every week
and adjust the dates for this calculation.
>
> I'm probably asking for heaven and earth (as is usually asked of me
at work) but is it possible?
>
> Wendy Bowen
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@s...
> ----- Original Message -----
> From: Lonnie Drew
> To: vantage@y...
> Sent: Thursday, August 09, 2001 2:45 PM
> Subject: [Vantage] Re: Job Progress Report Calcs
>
>
> Here goes ....
>
> #1 - You need to determine what the last week's begin and end
dates
> were. I tried the below and it worked.
>
> LastWeekBegin = 01/07/2001 + (7 * integer((today() -
01/07/2001) /
> 7)) - 7
> LastWeekEnd = LastWeekBegin + 6.
>
> I picked a date, 01/07/2001, corresponding to beginning of a work
> week (sunday). More info needed on your report setup to be
exact,
> but in general create a calculated field (bucket) something
like...
>
> iif(labordtl.payrolldate >= LastWeekBegin and
labordtl.payrolldate <=
> LastWeekEnd,labordtl.laborhrs,0).
>
> then create an aggregate on the bucket at a labordtl grouping
level
> that resets on a jobnum grouping.
>
> #2 - I would first get days remaining, DaysRem = today() -
> jobhead.duedate. Then WeeksRem = DaysRem / 7.
>
>
> HTH
> Lonnie
>
>
> --- In vantage@y..., "Wendy Bowen" <wpursche@s...> wrote:
> > I have a few challenging calculations that I'm having trouble
> with. In report builder I have a Job Progress report. This
report
> lists all open jobs and their hours. The report also lists total
> actual worked hours per job, total estimated hours per job, and
how
> many hours that we have left on the job.
> >
> > Okay, here's the challenge...............in addition to showing
the
> total hours I need to create two calculations:
> >
> > 1. show total
hours
> worked on each job for
>
the
> past week
> > 2. show how many
> weeks that we have left on
> the job
according
> to the requested due date
> >
> > Any ideas? Anyone...........anyone........
> >
> >
> > Wendy Bowen
> > Network Administrator
> > Schmald Tool & Die, Inc.
> > (810) 743-1600 ext.323
> > wpursche@s...
> >
> >
> > [Non-text portions of this message have been removed]
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
I have a few challenging calculations that I'm having trouble with. In report builder I have a Job Progress report. This report lists all open jobs and their hours. The report also lists total actual worked hours per job, total estimated hours per job, and how many hours that we have left on the job.

Okay, here's the challenge...............in addition to showing the total hours I need to create two calculations:

1. show total hours worked on each job for the past week
2. show how many weeks that we have left on the job according to the requested due date

Any ideas? Anyone...........anyone........

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...

[Non-text portions of this message have been removed]
Here goes ....

#1 - You need to determine what the last week's begin and end dates
were. I tried the below and it worked.

LastWeekBegin = 01/07/2001 + (7 * integer((today() - 01/07/2001) /
7)) - 7
LastWeekEnd = LastWeekBegin + 6.

I picked a date, 01/07/2001, corresponding to beginning of a work
week (sunday). More info needed on your report setup to be exact,
but in general create a calculated field (bucket) something like...

iif(labordtl.payrolldate >= LastWeekBegin and labordtl.payrolldate <=
LastWeekEnd,labordtl.laborhrs,0).

then create an aggregate on the bucket at a labordtl grouping level
that resets on a jobnum grouping.

#2 - I would first get days remaining, DaysRem = today() -
jobhead.duedate. Then WeeksRem = DaysRem / 7.

HTH
Lonnie

--- In vantage@y..., "Wendy Bowen" <wpursche@s...> wrote:
> I have a few challenging calculations that I'm having trouble
with. In report builder I have a Job Progress report. This report
lists all open jobs and their hours. The report also lists total
actual worked hours per job, total estimated hours per job, and how
many hours that we have left on the job.
>
> Okay, here's the challenge...............in addition to showing the
total hours I need to create two calculations:
>
> 1. show total hours
worked on each job for
the
past week
> 2. show how many
weeks that we have left on
the job according
to the requested due date
>
> Any ideas? Anyone...........anyone........
>
>
> Wendy Bowen
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@s...
>
>
> [Non-text portions of this message have been removed]
#2 worked perfectly!

But for #1 is there a way I can say take "Monday - Sunday" labor hours on that job without giving an exact date, just inputting the words "Monday, Sunday"? That way I wouldn't have to go in every week and adjust the dates for this calculation.

I'm probably asking for heaven and earth (as is usually asked of me at work) but is it possible?

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
----- Original Message -----
From: Lonnie Drew
To: vantage@yahoogroups.com
Sent: Thursday, August 09, 2001 2:45 PM
Subject: [Vantage] Re: Job Progress Report Calcs

Here goes ....

#1 - You need to determine what the last week's begin and end dates
were. I tried the below and it worked.

LastWeekBegin = 01/07/2001 + (7 * integer((today() - 01/07/2001) /
7)) - 7
LastWeekEnd = LastWeekBegin + 6.

I picked a date, 01/07/2001, corresponding to beginning of a work
week (sunday). More info needed on your report setup to be exact,
but in general create a calculated field (bucket) something like...

iif(labordtl.payrolldate >= LastWeekBegin and labordtl.payrolldate <=
LastWeekEnd,labordtl.laborhrs,0).

then create an aggregate on the bucket at a labordtl grouping level
that resets on a jobnum grouping.

#2 - I would first get days remaining, DaysRem = today() -
jobhead.duedate. Then WeeksRem = DaysRem / 7.

HTH
Lonnie

--- In vantage@y..., "Wendy Bowen" <wpursche@s...> wrote:
> I have a few challenging calculations that I'm having trouble
with. In report builder I have a Job Progress report. This report
lists all open jobs and their hours. The report also lists total
actual worked hours per job, total estimated hours per job, and how
many hours that we have left on the job.
>
> Okay, here's the challenge...............in addition to showing the
total hours I need to create two calculations:
>
> 1. show total hours
worked on each job for
the
past week
> 2. show how many
weeks that we have left on
the job according
to the requested due date
>
> Any ideas? Anyone...........anyone........
>
>
> Wendy Bowen
> Network Administrator
> Schmald Tool & Die, Inc.
> (810) 743-1600 ext.323
> wpursche@s...
>
>
> [Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]
Oops..

Amend for #2

I said "#2 - I would first get days remaining, DaysRem = today() -
jobhead.duedate. Then WeeksRem = DaysRem / 7."

Have to use absolute value function.

DaysRem = absolute(today() - jobhead.duedate)

Lonnie

--- In vantage@y..., "Lonnie Drew" <lonniedrew@c...> wrote:
> Here goes ....
>
> #1 - You need to determine what the last week's begin and end dates
> were. I tried the below and it worked.
>
> LastWeekBegin = 01/07/2001 + (7 * integer((today() - 01/07/2001) /
> 7)) - 7
> LastWeekEnd = LastWeekBegin + 6.
>
> I picked a date, 01/07/2001, corresponding to beginning of a work
> week (sunday). More info needed on your report setup to be exact,
> but in general create a calculated field (bucket) something like...
>
> iif(labordtl.payrolldate >= LastWeekBegin and labordtl.payrolldate
<=
> LastWeekEnd,labordtl.laborhrs,0).
>
> then create an aggregate on the bucket at a labordtl grouping level
> that resets on a jobnum grouping.
>
> #2 - I would first get days remaining, DaysRem = today() -
> jobhead.duedate. Then WeeksRem = DaysRem / 7.
>
>
> HTH
> Lonnie
>
>
> --- In vantage@y..., "Wendy Bowen" <wpursche@s...> wrote:
> > I have a few challenging calculations that I'm having trouble
> with. In report builder I have a Job Progress report. This report
> lists all open jobs and their hours. The report also lists total
> actual worked hours per job, total estimated hours per job, and how
> many hours that we have left on the job.
> >
> > Okay, here's the challenge...............in addition to showing
the
> total hours I need to create two calculations:
> >
> > 1. show total hours
> worked on each job for
> the
> past week
> > 2. show how many
> weeks that we have left on
> the job
according
> to the requested due date
> >
> > Any ideas? Anyone...........anyone........
> >
> >
> > Wendy Bowen
> > Network Administrator
> > Schmald Tool & Die, Inc.
> > (810) 743-1600 ext.323
> > wpursche@s...
> >
> >
> > [Non-text portions of this message have been removed]