RB calculation

Wendy,
If you are trying to capture the LaborHrs from 10/16/00 to 10/22/00, change
the order of the "Then, Else" values like this:

IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, LaborHrs, 0)

Regards
Jim Stetter


-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
Sent: Friday, October 27, 2000 10:05 AM
To: Vantage egroups list
Subject: [Vantage] RB calculation


I would like to calculate total labor hours per job in a range of dates.
I need to make this a calculated field because the rest of my report is
going to be from a larger date range. This is what I have so far and it
doesn't seem to be working.


IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, 0, LaborHrs)

Any ideas?

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



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


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)



[Non-text portions of this message have been removed]
I want to add to a calculation of our Monthly Shipping Report. I would like to have it report if a shipment was on time according to the Requested Date and 1 day after the requested date. I want to give a 1 day grace period of ontime delivery. My current calculation is this, but it does not verify. Help!

IIF(ShipDate <= ReqDate or 1 > ReqDate,'Yes','No')

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



[Non-text portions of this message have been removed]
Can anyone advise me on how to extract the first integer of the revision
number in order to use it in a calculation
Example
Rev.Num
1 UP
2 UP
3 UP
If Revision Number begins 1 then Production Qty divided by 1 =
sheets
(100,000 / 1 = 100,000)
If Revision Number begins 2 then Production Qty divided by 2 =
sheets
(100,000 / 2 = 50,000)

Thanks
Sophie
I would like to calculate total labor hours per job in a range of dates. I need to make this a calculated field because the rest of my report is going to be from a larger date range. This is what I have so far and it doesn't seem to be working.

IIF(ClockInDate >= 10/16/00 And ClockInDate <= 10/22/00, 0, LaborHrs)

Any ideas?

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



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