Judy
using Todd's formula collect the data in a calculated field like a
bucket. All the formulas appear inside <> in case mail formating
would break the lines.
The formaula for the Week is <Integer((ClockInDate - MinDate) / 7)
+ 1>
The formula for Week1 is <iif(Week = 1, PayHours, 0)>
The formula for Week2 is <iif(Week = 2, PayHours, 0)>
Then Total Week1 to Week1T, test for more than 40 and subtract
out the OT if there is any
Week1Hrs <iif(Week1T > 40, 40, Week1T)>
Week1OT <iif(Week1T > 40, Week1T - 40, 0)>
And so on for weeks 2, 3 & 4. I have a similar report for sales that
seperates sales by fiscal years. I put each fiscal in a serperate
column instead of rows like you have but rows should work also.
HTH
RussD
using Todd's formula collect the data in a calculated field like a
bucket. All the formulas appear inside <> in case mail formating
would break the lines.
The formaula for the Week is <Integer((ClockInDate - MinDate) / 7)
+ 1>
The formula for Week1 is <iif(Week = 1, PayHours, 0)>
The formula for Week2 is <iif(Week = 2, PayHours, 0)>
Then Total Week1 to Week1T, test for more than 40 and subtract
out the OT if there is any
Week1Hrs <iif(Week1T > 40, 40, Week1T)>
Week1OT <iif(Week1T > 40, Week1T - 40, 0)>
And so on for weeks 2, 3 & 4. I have a similar report for sales that
seperates sales by fiscal years. I put each fiscal in a serperate
column instead of rows like you have but rows should work also.
HTH
RussD
On 18 Jun 2001, at 11:49, Judy Havlik wrote:
> Thanks, Todd...I'm so close where I now have the weeks separated by using
> MinDate (aggregate minimum date) then the calculation for CALCWEEK as
> IIF(Mindate + 6 > ActualClockinDate, 1, IIF(Mindate + 13 >
> ActualClockinDate, 2, IIF(Mindate + 20 > ActualClockinDate, 3, IIF(Mindate
> + 27 > ActualClockinDate, 4, 5)))). I now have the weeks separated.
>
> Now, I'm trying to add the PayHours in an aggregate using CalcWeek but I'm
> coming up with:
>
> 8.00 Calcweek = 1
> 8.00 Total
>
> 8.00 Calcweek = 1
> 8.00 Calcweek = 1
> 8.00 Calcweek = 1
> 8.00 Calcweek = 1
> 8.00 Calcweek = 2
> 40.00 Total
>
> Any idea why it would do this?
>
> Sincerely,
> Judy H. : )
> Plitek, L.L.C.
> Phone: 847-827-6680, Ext. 223
> Fax: 847-827-6733
> E-mail: judy.havlik@...
> Website: www.plitek.com
>
>
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@...]
> Sent: Monday, June 18, 2001 11:26 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Report Builder Question - Challenge your skills
>
>
> You can get the week by setting using the following:
> INTEGER((ClockInDate - First-Date) / 7) + 1
> where ClockInDate is from the LaborDetail (or wherever)
> and First-Date is any starting date (start date of the first week)
> [06/20/2001 - 06/03/2001 = 17]
> [17 / 7 = 2.42 or 2]
> [2+1 = 3]
> so 6/20 is in week 3 since 6/3
>
> You could get First-Date from the report filter range by extracting from the
> string created by running REPORT-FILTER() through an aggregate (such as
> Minumum). This way you can run the report for any week starting date thru
> any ending date.
> -Todd C.
>
>
> -----Original Message-----
> From: Judy Havlik [mailto:judy.havlik@...]
> Sent: Monday, June 18, 2001 11:00 AM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Report Builder Question - Challenge your skills
>
>
> I'm creating a report in report builder showing Weekly/Monthly Production
> Regular and Overtime hours.
>
> First week of the month: The report calculates anything over 40 hours as
> overtime, with "40" hours being hardcoded into the calculation. Naturally,
> with only one week on the report, everything comes out fine.
>
> When the report is run for the second, third, and fourth week of the month,
> obviously the "40" is no longer valid in determining overtime. All of our
> weeks begin on Sunday and end on Saturday.
>
> The report will be run for the first week, then for the first and second
> week, then first, second, third, etc. Does anyone know if there is a way to
> differentiate the weeks in Vantage so I end up with a report like:
>
> Week 1 Total regular hours Total O/T hours
> Week 2 Total regular hours Total O/T hours
> Week 3 Total regular hours Total O/T hours
> Week 4 Total regular hours Total O/T hours
> Week 5 Total regular hours Total O/T hours
>
> Our Production report for May went from 4/29/01 thru 6/2/01 for 5 full weeks
> data.
>
> Sincerely,
> Judy H. : )
> Plitek, L.L.C.
> Phone: 847-827-6680, Ext. 223
> Fax: 847-827-6733
> E-mail: judy.havlik@...
> Website: www.plitek.com
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
> 183:N/A=675622/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9928
> 80026> []
>
> <http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
> l/S=1700007183:N/A=675622/rand=369513878>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.> Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> <http://docs.yahoo.com/info/terms/> Service.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other '
goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com