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
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]