Crystal 2nd Pass Function

Yahoo Archive
1
Glad I could help.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
wendorff1
Sent: Friday, December 02, 2005 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2nd Pass Function


You are correct - that was my mistake. Thanks!!

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...> wrote:
>
> Should it be a sum and not a function then? @ is for a function I
think you
> need to look at the formula in the editor again the sum will be listed
> a little lower.
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person at
a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> wendorff1
> Sent: Friday, December 02, 2005 9:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal 2nd Pass Function
>
>
> Sum field that delivers a subtotal of production hours by employee.
>
>
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> >
> > I'll bite what does the @production hours by employee formula do?
> >
> > Frank Zeigafuse
> > Innovative Office Products
> > General Manager
> > Direct Phone: 610-559-6369
> > Email: fzeigafuse@L...
> >
> > Visit www.one.org to see how the world can be changed one person at
> a time.
> >
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > wendorff1
> > Sent: Thursday, December 01, 2005 4:04 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal 2nd Pass Function
> >
> >
> > I�m using crystal 8.5 to create an employee efficiency report.
> >
> > I�m trying to turn one of my formulas into a 2nd pass function so
> I can
> > divide by a sum field.
> >
> > I created a new formula which takes a field and finds the percentage
> of the
> > Sum field. I�ve tried both the �whileprinting� and
> > �evaluateafter� functions.
> >
> > EvaluateAfter ({@Production Hours by Employee}) ;
> > if {JobOper.ProdStandard} = 0 then 0
> > else if {LaborDtl.LaborType} = 'S' then 0
> > else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})
> >
> > Regardless of what I try, my formula returns a value of 1.
> > @ Production Hours is my sum field.
> >
> > Can anyone offer a suggestion?
> >
> > TIA!
> >
> > Kelly Wendorff
> > Cost Accounting Manager
> > SteelCraft Corporation
> > www.scc-wi.com
> >
> >
> >
> >
> >
> >
> >
> >
> > 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
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
>
> 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
> Yahoo! Groups Links
>








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
Yahoo! Groups Links
2
I'm using crystal 8.5 to create an employee efficiency report.

I'm trying to turn one of my formulas into a 2nd pass function so I
can divide by a sum field.

I created a new formula which takes a field and finds the percentage
of the Sum field. I've tried both the "whileprinting" and
"evaluateafter" functions.

EvaluateAfter ({@Production Hours by Employee}) ;
if {JobOper.ProdStandard} = 0 then 0
else if {LaborDtl.LaborType} = 'S' then 0
else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})

Regardless of what I try, my formula returns a value of 1.
@ Production Hours is my sum field.

Can anyone offer a suggestion?

TIA!

Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
www.scc-wi.com
3
I'll bite what does the @production hours by employee formula do?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
wendorff1
Sent: Thursday, December 01, 2005 4:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal 2nd Pass Function


I�m using crystal 8.5 to create an employee efficiency report.

I�m trying to turn one of my formulas into a 2nd pass function so I can
divide by a sum field.

I created a new formula which takes a field and finds the percentage of the
Sum field. I�ve tried both the �whileprinting� and
�evaluateafter� functions.

EvaluateAfter ({@Production Hours by Employee}) ;
if {JobOper.ProdStandard} = 0 then 0
else if {LaborDtl.LaborType} = 'S' then 0
else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})

Regardless of what I try, my formula returns a value of 1.
@ Production Hours is my sum field.

Can anyone offer a suggestion?

TIA!

Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
www.scc-wi.com








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
Yahoo! Groups Links
4
Sum field that delivers a subtotal of production hours by employee.




--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...> wrote:
>
> I'll bite what does the @production hours by employee formula do?
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person at
a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> wendorff1
> Sent: Thursday, December 01, 2005 4:04 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2nd Pass Function
>
>
> I�m using crystal 8.5 to create an employee efficiency report.
>
> I�m trying to turn one of my formulas into a 2nd pass function so
I can
> divide by a sum field.
>
> I created a new formula which takes a field and finds the percentage
of the
> Sum field. I�ve tried both the �whileprinting� and
> �evaluateafter� functions.
>
> EvaluateAfter ({@Production Hours by Employee}) ;
> if {JobOper.ProdStandard} = 0 then 0
> else if {LaborDtl.LaborType} = 'S' then 0
> else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})
>
> Regardless of what I try, my formula returns a value of 1.
> @ Production Hours is my sum field.
>
> Can anyone offer a suggestion?
>
> TIA!
>
> Kelly Wendorff
> Cost Accounting Manager
> SteelCraft Corporation
> www.scc-wi.com
>
>
>
>
>
>
>
>
> 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
> Yahoo! Groups Links
>
5
Kelly,

This might help

http://support.businessobjects.com/library/kbase/articles/c2007015.asp

Dan Shallbetter
States Electric Mfg.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of wendorff1
Sent: Friday, December 02, 2005 8:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2nd Pass Function


Sum field that delivers a subtotal of production hours by employee.




--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...> wrote:
>
> I'll bite what does the @production hours by employee formula do?
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person at
a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> wendorff1
> Sent: Thursday, December 01, 2005 4:04 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2nd Pass Function
>
>
> I�m using crystal 8.5 to create an employee efficiency report.
>
> I�m trying to turn one of my formulas into a 2nd pass function so
I can
> divide by a sum field.
>
> I created a new formula which takes a field and finds the percentage
of the
> Sum field. I�ve tried both the �whileprinting� and
> �evaluateafter� functions.
>
> EvaluateAfter ({@Production Hours by Employee}) ;
> if {JobOper.ProdStandard} = 0 then 0
> else if {LaborDtl.LaborType} = 'S' then 0
> else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})
>
> Regardless of what I try, my formula returns a value of 1.
> @ Production Hours is my sum field.
>
> Can anyone offer a suggestion?
>
> TIA!
>
> Kelly Wendorff
> Cost Accounting Manager
> SteelCraft Corporation
> www.scc-wi.com
>
>
>
>
>
>



[Non-text portions of this message have been removed]
6
I appreciate the response - that is a good document and i will
experiment with the running total idea.

However, I have not been able to figure out why the original formula
doesn't work. The sum field should be calculated during Pass 1. In
the second formula (@ production hours by employee) I specifically
direct it to perform the function after the sum field has been
calculated (using either Whileprinting or evaluateafter should
accomplish this).

Is my logic off? I don't think i should need to create a running
total to divide by a sum field that is calculated in Pass 1. Either
the sum field is not calculated in Pass1 or I'm not using the
"evaluateafter" function properly.

Thanks,

Kelly

--- In vantage@yahoogroups.com, "Dan Shallbetter" <dans@s...> wrote:
>
> Kelly,
>
> This might help
>
> http://support.businessobjects.com/library/kbase/articles/c2007015.asp
>
> Dan Shallbetter
> States Electric Mfg.
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of wendorff1
> Sent: Friday, December 02, 2005 8:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal 2nd Pass Function
>
>
> Sum field that delivers a subtotal of production hours by employee.
>
>
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> >
> > I'll bite what does the @production hours by employee formula do?
> >
> > Frank Zeigafuse
> > Innovative Office Products
> > General Manager
> > Direct Phone: 610-559-6369
> > Email: fzeigafuse@L...
> >
> > Visit www.one.org to see how the world can be changed one person at
> a time.
> >
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > wendorff1
> > Sent: Thursday, December 01, 2005 4:04 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal 2nd Pass Function
> >
> >
> > I�m using crystal 8.5 to create an employee efficiency report.
> >
> > I�m trying to turn one of my formulas into a 2nd pass function so
> I can
> > divide by a sum field.
> >
> > I created a new formula which takes a field and finds the percentage
> of the
> > Sum field. I�ve tried both the �whileprinting� and
> > �evaluateafter� functions.
> >
> > EvaluateAfter ({@Production Hours by Employee}) ;
> > if {JobOper.ProdStandard} = 0 then 0
> > else if {LaborDtl.LaborType} = 'S' then 0
> > else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})
> >
> > Regardless of what I try, my formula returns a value of 1.
> > @ Production Hours is my sum field.
> >
> > Can anyone offer a suggestion?
> >
> > TIA!
> >
> > Kelly Wendorff
> > Cost Accounting Manager
> > SteelCraft Corporation
> > www.scc-wi.com
> >
> >
> >
> >
> >
> >
>
>
>
> [Non-text portions of this message have been removed]
>
7
Should it be a sum and not a function then? @ is for a function I think you
need to look at the formula in the editor again the sum will be listed a
little lower.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
wendorff1
Sent: Friday, December 02, 2005 9:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2nd Pass Function


Sum field that delivers a subtotal of production hours by employee.




--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...> wrote:
>
> I'll bite what does the @production hours by employee formula do?
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person at
a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> wendorff1
> Sent: Thursday, December 01, 2005 4:04 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2nd Pass Function
>
>
> I�m using crystal 8.5 to create an employee efficiency report.
>
> I�m trying to turn one of my formulas into a 2nd pass function so
I can
> divide by a sum field.
>
> I created a new formula which takes a field and finds the percentage
of the
> Sum field. I�ve tried both the �whileprinting� and
> �evaluateafter� functions.
>
> EvaluateAfter ({@Production Hours by Employee}) ;
> if {JobOper.ProdStandard} = 0 then 0
> else if {LaborDtl.LaborType} = 'S' then 0
> else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})
>
> Regardless of what I try, my formula returns a value of 1.
> @ Production Hours is my sum field.
>
> Can anyone offer a suggestion?
>
> TIA!
>
> Kelly Wendorff
> Cost Accounting Manager
> SteelCraft Corporation
> www.scc-wi.com
>
>
>
>
>
>
>
>
> 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
> Yahoo! Groups Links
>







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
Yahoo! Groups Links
8
You are correct - that was my mistake. Thanks!!

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...> wrote:
>
> Should it be a sum and not a function then? @ is for a function I
think you
> need to look at the formula in the editor again the sum will be listed a
> little lower.
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person at
a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> wendorff1
> Sent: Friday, December 02, 2005 9:50 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal 2nd Pass Function
>
>
> Sum field that delivers a subtotal of production hours by employee.
>
>
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
> >
> > I'll bite what does the @production hours by employee formula do?
> >
> > Frank Zeigafuse
> > Innovative Office Products
> > General Manager
> > Direct Phone: 610-559-6369
> > Email: fzeigafuse@L...
> >
> > Visit www.one.org to see how the world can be changed one person at
> a time.
> >
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > wendorff1
> > Sent: Thursday, December 01, 2005 4:04 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal 2nd Pass Function
> >
> >
> > I�m using crystal 8.5 to create an employee efficiency report.
> >
> > I�m trying to turn one of my formulas into a 2nd pass function so
> I can
> > divide by a sum field.
> >
> > I created a new formula which takes a field and finds the percentage
> of the
> > Sum field. I�ve tried both the �whileprinting� and
> > �evaluateafter� functions.
> >
> > EvaluateAfter ({@Production Hours by Employee}) ;
> > if {JobOper.ProdStandard} = 0 then 0
> > else if {LaborDtl.LaborType} = 'S' then 0
> > else ({LaborDtl.LaborHrs}/{@Production Hours by Employee})
> >
> > Regardless of what I try, my formula returns a value of 1.
> > @ Production Hours is my sum field.
> >
> > Can anyone offer a suggestion?
> >
> > TIA!
> >
> > Kelly Wendorff
> > Cost Accounting Manager
> > SteelCraft Corporation
> > www.scc-wi.com
> >
> >
> >
> >
> >
> >
> >
> >
> > 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
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
>
> 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
> Yahoo! Groups Links
>