RB calculation


(system) #1
Sophie, try an equation of this form:

IIF(SUBSTRING(Rev.Num,1,1) = '1',(100000/1),IIF(SUBSTRING(Rev.Num,1,1) =
'2',(100000/2),(100000/3)))

The first number in the substring function is the starting character, and
the second is the number of sequential characters to pull.

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

(system) #2
Try:

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


_________________
John Koppes
Systems Administrator
PRECISION MACHINE AND MANUFACTURING COMPANY
Address: PO Box 157
Story City, Iowa 50248
Phone: (515) 733-5181 Ext. 256
Fax: (515) 733-4220
Email: jkoppes@...



"Wendy
Pursche" To: "Vantage egroups list" <vantage@egroups.com>
<wpursche@sch cc:
mald.com> Subject: [Vantage] RB calculation

07/24/00
01:15 PM
Please
respond to
vantage






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]


------------------------------------------------------------------------
Still looking for the complete Application Server solution?
Find answers and a $75 gift certificate at the Intraware App Server
Webinar. Sign up at:
http://click.egroups.com/1/6756/13/_/411782/_/964462621/
------------------------------------------------------------------------

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.)




______________________________________________________________________


This document should only be read by those persons to whom it is
addressed and is not intended to be relied upon by any person without
subsequent written confirmation of its contents. Accordingly, PRECISION
MACHINE AND MANUFACTURING COMPANY disclaims all responsibility and accepts
no liability (including in negligence) for the consequences for any person
acting, or refraining from acting, on such information prior to the receipt
by those persons of subsequent written confirmation.

If you have received this E-mail message in error, please notify us
immediately by telephone. Please also destroy and delete the message from
your computer.

Contact:
By Phone: Systems Administrator at (515)-733-5181
By Email: sysadmin@...

Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this E-mail message is
strictly prohibited.

(system) #3
I think you will cover both cases more simply with:

iif (shipdate <= (ReqDate + 1), True, False)

Jim Stetter
Snow Filtration
-----Original Message-----
From: jkoppes@... [mailto:jkoppes@...]
Sent: Monday, July 24, 2000 2:19 PM
To: vantage@egroups.com
Subject: Re: [Vantage] RB calculation



Try:

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


_________________
John Koppes
Systems Administrator
PRECISION MACHINE AND MANUFACTURING COMPANY
Address: PO Box 157
Story City, Iowa 50248
Phone: (515) 733-5181 Ext. 256
Fax: (515) 733-4220
Email: jkoppes@precisionmachine.


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