Crystal date formula, Help

Yahoo Archive
1
Awesome!
Â
I want to say thank you to all of you, this site and all of you have been a huge help and provided me with some very helpfull information.
Â
I was able to paste the formula from the web site and modify it to get exactly what I was looking for. I will be spending some more tme here and adding this to my favorites.
Â
I will also be adding the book you recommended to my desk.
Â
Thank you
I hope I can return the favor some day.
Â
Ken
--- On Sun, 2/22/09, Mark Wonsil <mark_wonsil@...> wrote:


From: Mark Wonsil <mark_wonsil@...>
Subject: RE: [Vantage] Re: Crystal date formula, Help
To: vantage@yahoogroups.com
Date: Sunday, February 22, 2009, 5:36 AM






> The piece I cannot figure out is how to get the number of workdays
> in the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-
> 09 > = 7 workdays)

A Google search provides:
http://www.kenhamad y.com/form01. shtml



















[Non-text portions of this message have been removed]
2
I have a commission report I am building and would like to have a
formula to identify the number of workdays between the selected date
range that the report is ran against.

The tables I am using are:
InvDtl
InvMisc
InvHead
Customer

I have built a report that identifies invoice extended price for each
salesman for a selected date range

We are gauging a bonus payout based on last year's sales performance.

I have the amount of last year's sales per salesman (this is my
annual target) I can divide this by 250 for a daily target

I have the report set up to print "From invoice date" / "To Invoice
date" (this is my date range) Not sure how to get the number of
workdays out of this.

I am trying to display a running comparison with actual sales from
date range (current sales), to a comparison of last years
sales "average" annual sales divided by the number of workdays in the
selected date range.

The piece I cannot figure out is how to get the number of workdays in
the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-09
= 7 workdays)

I hope I have explained this ok!
Thank you for any direction.

Ken
3
Without getting into detail, if you want true workdays, not only do you need to subtract Saturdays and Sundays, but you also need to subtract holidays. If you are really on top of things, you may want to subtract vacation and sick days, as well. A few (US) holidays are defined as specific dates (New Year's Day, Independence Day, and Christmas) and are reasonably easy to account for. The other holidays are more difficult, especially if you throw in things like Good Friday. The only solution I have come up with is to maintain a database of all the holidays and reference those in my report. This is not a trivial task, unfortunately. However, you also do not want to hold your people accountable for a level of work when they are not even at work.

Sorry I did not answer your question, but hopefully I gave you a few thoughts.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kenjirak
Sent: Thursday, February 19, 2009 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal date formula, Help


I have a commission report I am building and would like to have a
formula to identify the number of workdays between the selected date
range that the report is ran against.

The tables I am using are:
InvDtl
InvMisc
InvHead
Customer

I have built a report that identifies invoice extended price for each
salesman for a selected date range

We are gauging a bonus payout based on last year's sales performance.

I have the amount of last year's sales per salesman (this is my
annual target) I can divide this by 250 for a daily target

I have the report set up to print "From invoice date" / "To Invoice
date" (this is my date range) Not sure how to get the number of
workdays out of this.

I am trying to display a running comparison with actual sales from
date range (current sales), to a comparison of last years
sales "average" annual sales divided by the number of workdays in the
selected date range.

The piece I cannot figure out is how to get the number of workdays in
the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-09
= 7 workdays)

I hope I have explained this ok!
Thank you for any direction.

Ken




[Non-text portions of this message have been removed]
4
What I would say as well is that you're going to probably need to
leverage running totals, and define a formula field that determines for
each date in your report detail whether or not this is a day you can
count. Then you can use the running total (which uses the
CountThisDay() formula) to determine the denominator of your
computation, probably in the report footer.



Depending on what you're doing, you may need to process your data
twice - maybe grouped in the report itself, but running through all of
the Details rows to determine your number of countable days. You can
insert a subreport in say the report header and link that subreport to
the same dataset. This gives you a way to do what you want.



Just thinking off the top of my head.



-bws



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Thursday, February 19, 2009 3:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal date formula, Help



Without getting into detail, if you want true workdays, not only do you
need to subtract Saturdays and Sundays, but you also need to subtract
holidays. If you are really on top of things, you may want to subtract
vacation and sick days, as well. A few (US) holidays are defined as
specific dates (New Year's Day, Independence Day, and Christmas) and are
reasonably easy to account for. The other holidays are more difficult,
especially if you throw in things like Good Friday. The only solution I
have come up with is to maintain a database of all the holidays and
reference those in my report. This is not a trivial task, unfortunately.
However, you also do not want to hold your people accountable for a
level of work when they are not even at work.

Sorry I did not answer your question, but hopefully I gave you a few
thoughts.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of kenjirak
Sent: Thursday, February 19, 2009 1:48 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal date formula, Help

I have a commission report I am building and would like to have a
formula to identify the number of workdays between the selected date
range that the report is ran against.

The tables I am using are:
InvDtl
InvMisc
InvHead
Customer

I have built a report that identifies invoice extended price for each
salesman for a selected date range

We are gauging a bonus payout based on last year's sales performance.

I have the amount of last year's sales per salesman (this is my
annual target) I can divide this by 250 for a daily target

I have the report set up to print "From invoice date" / "To Invoice
date" (this is my date range) Not sure how to get the number of
workdays out of this.

I am trying to display a running comparison with actual sales from
date range (current sales), to a comparison of last years
sales "average" annual sales divided by the number of workdays in the
selected date range.

The piece I cannot figure out is how to get the number of workdays in
the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-09
= 7 workdays)

I hope I have explained this ok!
Thank you for any direction.

Ken

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





[Non-text portions of this message have been removed]
5
Thank you guys for the reply.

I am new to this crystal stuff, I think I am following where Brian
is comming from, but am not farmiliar enough with formula options
(or creation)to see this through. I have been using "Crystal Reports
XI" Official guide by Neil Fitzgerald to learn my way into Crystal
reports. Does anyone know of a book to purchase or a place to go to
find sample formulas that can be used as templates to build from and
help me find my way through this stuff?

I will try to work with this CountThisDay formula and see where it
gets me.

Thanks again for the help
Ken

--- In vantage@yahoogroups.com, "Brian W. Spolarich "
<bspolarich@...> wrote:
>
> What I would say as well is that you're going to probably need to
> leverage running totals, and define a formula field that
determines for
> each date in your report detail whether or not this is a day you
can
> count. Then you can use the running total (which uses the
> CountThisDay() formula) to determine the denominator of your
> computation, probably in the report footer.
>
>
>
> Depending on what you're doing, you may need to process your data
> twice - maybe grouped in the report itself, but running through
all of
> the Details rows to determine your number of countable days. You
can
> insert a subreport in say the report header and link that
subreport to
> the same dataset. This gives you a way to do what you want.
>
>
>
> Just thinking off the top of my head.
>
>
>
> -bws
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Thomas Rose
> Sent: Thursday, February 19, 2009 3:22 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal date formula, Help
>
>
>
> Without getting into detail, if you want true workdays, not only
do you
> need to subtract Saturdays and Sundays, but you also need to
subtract
> holidays. If you are really on top of things, you may want to
subtract
> vacation and sick days, as well. A few (US) holidays are defined as
> specific dates (New Year's Day, Independence Day, and Christmas)
and are
> reasonably easy to account for. The other holidays are more
difficult,
> especially if you throw in things like Good Friday. The only
solution I
> have come up with is to maintain a database of all the holidays and
> reference those in my report. This is not a trivial task,
unfortunately.
> However, you also do not want to hold your people accountable for a
> level of work when they are not even at work.
>
> Sorry I did not answer your question, but hopefully I gave you a
few
> thoughts.
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of kenjirak
> Sent: Thursday, February 19, 2009 1:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal date formula, Help
>
> I have a commission report I am building and would like to have a
> formula to identify the number of workdays between the selected
date
> range that the report is ran against.
>
> The tables I am using are:
> InvDtl
> InvMisc
> InvHead
> Customer
>
> I have built a report that identifies invoice extended price for
each
> salesman for a selected date range
>
> We are gauging a bonus payout based on last year's sales
performance.
>
> I have the amount of last year's sales per salesman (this is my
> annual target) I can divide this by 250 for a daily target
>
> I have the report set up to print "From invoice date" / "To Invoice
> date" (this is my date range) Not sure how to get the number of
> workdays out of this.
>
> I am trying to display a running comparison with actual sales from
> date range (current sales), to a comparison of last years
> sales "average" annual sales divided by the number of workdays in
the
> selected date range.
>
> The piece I cannot figure out is how to get the number of workdays
in
> the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-
09
> = 7 workdays)
>
> I hope I have explained this ok!
> Thank you for any direction.
>
> Ken
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Hi Ken,



Try this site. It has been a great help to me.
http://www.kenhamady.com/form01.shtml



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of kenjirak
Sent: Friday, February 20, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal date formula, Help



Thank you guys for the reply.

I am new to this crystal stuff, I think I am following where Brian
is comming from, but am not farmiliar enough with formula options
(or creation)to see this through. I have been using "Crystal Reports
XI" Official guide by Neil Fitzgerald to learn my way into Crystal
reports. Does anyone know of a book to purchase or a place to go to
find sample formulas that can be used as templates to build from and
help me find my way through this stuff?

I will try to work with this CountThisDay formula and see where it
gets me.

Thanks again for the help
Ken

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich "
<bspolarich@...> wrote:
>
> What I would say as well is that you're going to probably need to
> leverage running totals, and define a formula field that
determines for
> each date in your report detail whether or not this is a day you
can
> count. Then you can use the running total (which uses the
> CountThisDay() formula) to determine the denominator of your
> computation, probably in the report footer.
>
>
>
> Depending on what you're doing, you may need to process your data
> twice - maybe grouped in the report itself, but running through
all of
> the Details rows to determine your number of countable days. You
can
> insert a subreport in say the report header and link that
subreport to
> the same dataset. This gives you a way to do what you want.
>
>
>
> Just thinking off the top of my head.
>
>
>
> -bws
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Thomas Rose
> Sent: Thursday, February 19, 2009 3:22 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Crystal date formula, Help
>
>
>
> Without getting into detail, if you want true workdays, not only
do you
> need to subtract Saturdays and Sundays, but you also need to
subtract
> holidays. If you are really on top of things, you may want to
subtract
> vacation and sick days, as well. A few (US) holidays are defined as
> specific dates (New Year's Day, Independence Day, and Christmas)
and are
> reasonably easy to account for. The other holidays are more
difficult,
> especially if you throw in things like Good Friday. The only
solution I
> have come up with is to maintain a database of all the holidays and
> reference those in my report. This is not a trivial task,
unfortunately.
> However, you also do not want to hold your people accountable for a
> level of work when they are not even at work.
>
> Sorry I did not answer your question, but hopefully I gave you a
few
> thoughts.
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of kenjirak
> Sent: Thursday, February 19, 2009 1:48 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal date formula, Help
>
> I have a commission report I am building and would like to have a
> formula to identify the number of workdays between the selected
date
> range that the report is ran against.
>
> The tables I am using are:
> InvDtl
> InvMisc
> InvHead
> Customer
>
> I have built a report that identifies invoice extended price for
each
> salesman for a selected date range
>
> We are gauging a bonus payout based on last year's sales
performance.
>
> I have the amount of last year's sales per salesman (this is my
> annual target) I can divide this by 250 for a daily target
>
> I have the report set up to print "From invoice date" / "To Invoice
> date" (this is my date range) Not sure how to get the number of
> workdays out of this.
>
> I am trying to display a running comparison with actual sales from
> date range (current sales), to a comparison of last years
> sales "average" annual sales divided by the number of workdays in
the
> selected date range.
>
> The piece I cannot figure out is how to get the number of workdays
in
> the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-
09
> = 7 workdays)
>
> I hope I have explained this ok!
> Thank you for any direction.
>
> Ken
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
Ken,
I found the book Crystal Reports XI Complete Reference by George Peck to be very helpful for all of the functions including examples of each.
Â
-Karl

--- On Fri, 2/20/09, kenjirak <kenjirak@...> wrote:

From: kenjirak <kenjirak@...>
Subject: [Vantage] Re: Crystal date formula, Help
To: vantage@yahoogroups.com
Date: Friday, February 20, 2009, 8:10 AM






Thank you guys for the reply.

I am new to this crystal stuff, I think I am following where Brian
is comming from, but am not farmiliar enough with formula options
(or creation)to see this through. I have been using "Crystal Reports
XI" Official guide by Neil Fitzgerald to learn my way into Crystal
reports. Does anyone know of a book to purchase or a place to go to
find sample formulas that can be used as templates to build from and
help me find my way through this stuff?

I will try to work with this CountThisDay formula and see where it
gets me.

Thanks again for the help
Ken

--- In vantage@yahoogroups .com, "Brian W. Spolarich "
<bspolarich@ ...> wrote:
>
> What I would say as well is that you're going to probably need to
> leverage running totals, and define a formula field that
determines for
> each date in your report detail whether or not this is a day you
can
> count. Then you can use the running total (which uses the
> CountThisDay( ) formula) to determine the denominator of your
> computation, probably in the report footer.
>
>
>
> Depending on what you're doing, you may need to process your data
> twice - maybe grouped in the report itself, but running through
all of
> the Details rows to determine your number of countable days. You
can
> insert a subreport in say the report header and link that
subreport to
> the same dataset. This gives you a way to do what you want.
>
>
>
> Just thinking off the top of my head.
>
>
>
> -bws
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
> Of Thomas Rose
> Sent: Thursday, February 19, 2009 3:22 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Crystal date formula, Help
>
>
>
> Without getting into detail, if you want true workdays, not only
do you
> need to subtract Saturdays and Sundays, but you also need to
subtract
> holidays. If you are really on top of things, you may want to
subtract
> vacation and sick days, as well. A few (US) holidays are defined as
> specific dates (New Year's Day, Independence Day, and Christmas)
and are
> reasonably easy to account for. The other holidays are more
difficult,
> especially if you throw in things like Good Friday. The only
solution I
> have come up with is to maintain a database of all the holidays and
> reference those in my report. This is not a trivial task,
unfortunately.
> However, you also do not want to hold your people accountable for a
> level of work when they are not even at work.
>
> Sorry I did not answer your question, but hopefully I gave you a
few
> thoughts.
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror. com<http://www.electric mirror.com>
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> [mailto:vantage@yahoogroups .com <mailto:vantage%
40yahoogroups. com> ] On
> Behalf Of kenjirak
> Sent: Thursday, February 19, 2009 1:48 PM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Crystal date formula, Help
>
> I have a commission report I am building and would like to have a
> formula to identify the number of workdays between the selected
date
> range that the report is ran against.
>
> The tables I am using are:
> InvDtl
> InvMisc
> InvHead
> Customer
>
> I have built a report that identifies invoice extended price for
each
> salesman for a selected date range
>
> We are gauging a bonus payout based on last year's sales
performance.
>
> I have the amount of last year's sales per salesman (this is my
> annual target) I can divide this by 250 for a daily target
>
> I have the report set up to print "From invoice date" / "To Invoice
> date" (this is my date range) Not sure how to get the number of
> workdays out of this.
>
> I am trying to display a running comparison with actual sales from
> date range (current sales), to a comparison of last years
> sales "average" annual sales divided by the number of workdays in
the
> selected date range.
>
> The piece I cannot figure out is how to get the number of workdays
in
> the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-
09
> = 7 workdays)
>
> I hope I have explained this ok!
> Thank you for any direction.
>
> Ken
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>



















[Non-text portions of this message have been removed]
8
I will second that comment. That book sits right behind my desk and is my go to for any Crystal XI questions. It is what I used to learn Crystal.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karl Dash
Sent: Friday, February 20, 2009 10:30 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal date formula, Help


Ken,
I found the book Crystal Reports XI Complete Reference by George Peck to be very helpful for all of the functions including examples of each.

-Karl

--- On Fri, 2/20/09, kenjirak <kenjirak@...<mailto:kenjirak%40yahoo.com>> wrote:

From: kenjirak <kenjirak@...<mailto:kenjirak%40yahoo.com>>
Subject: [Vantage] Re: Crystal date formula, Help
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Date: Friday, February 20, 2009, 8:10 AM

Thank you guys for the reply.

I am new to this crystal stuff, I think I am following where Brian
is comming from, but am not farmiliar enough with formula options
(or creation)to see this through. I have been using "Crystal Reports
XI" Official guide by Neil Fitzgerald to learn my way into Crystal
reports. Does anyone know of a book to purchase or a place to go to
find sample formulas that can be used as templates to build from and
help me find my way through this stuff?

I will try to work with this CountThisDay formula and see where it
gets me.

Thanks again for the help
Ken

--- In vantage@yahoogroups .com, "Brian W. Spolarich "
<bspolarich@ ...> wrote:
>
> What I would say as well is that you're going to probably need to
> leverage running totals, and define a formula field that
determines for
> each date in your report detail whether or not this is a day you
can
> count. Then you can use the running total (which uses the
> CountThisDay( ) formula) to determine the denominator of your
> computation, probably in the report footer.
>
>
>
> Depending on what you're doing, you may need to process your data
> twice - maybe grouped in the report itself, but running through
all of
> the Details rows to determine your number of countable days. You
can
> insert a subreport in say the report header and link that
subreport to
> the same dataset. This gives you a way to do what you want.
>
>
>
> Just thinking off the top of my head.
>
>
>
> -bws
>
>
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
> Of Thomas Rose
> Sent: Thursday, February 19, 2009 3:22 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Crystal date formula, Help
>
>
>
> Without getting into detail, if you want true workdays, not only
do you
> need to subtract Saturdays and Sundays, but you also need to
subtract
> holidays. If you are really on top of things, you may want to
subtract
> vacation and sick days, as well. A few (US) holidays are defined as
> specific dates (New Year's Day, Independence Day, and Christmas)
and are
> reasonably easy to account for. The other holidays are more
difficult,
> especially if you throw in things like Good Friday. The only
solution I
> have come up with is to maintain a database of all the holidays and
> reference those in my report. This is not a trivial task,
unfortunately.
> However, you also do not want to hold your people accountable for a
> level of work when they are not even at work.
>
> Sorry I did not answer your question, but hopefully I gave you a
few
> thoughts.
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> F 425 491-8200
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror. com<http://www.electric mirror.com>
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> [mailto:vantage@yahoogroups .com <mailto:vantage%
40yahoogroups. com> ] On
> Behalf Of kenjirak
> Sent: Thursday, February 19, 2009 1:48 PM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Crystal date formula, Help
>
> I have a commission report I am building and would like to have a
> formula to identify the number of workdays between the selected
date
> range that the report is ran against.
>
> The tables I am using are:
> InvDtl
> InvMisc
> InvHead
> Customer
>
> I have built a report that identifies invoice extended price for
each
> salesman for a selected date range
>
> We are gauging a bonus payout based on last year's sales
performance.
>
> I have the amount of last year's sales per salesman (this is my
> annual target) I can divide this by 250 for a daily target
>
> I have the report set up to print "From invoice date" / "To Invoice
> date" (this is my date range) Not sure how to get the number of
> workdays out of this.
>
> I am trying to display a running comparison with actual sales from
> date range (current sales), to a comparison of last years
> sales "average" annual sales divided by the number of workdays in
the
> selected date range.
>
> The piece I cannot figure out is how to get the number of workdays
in
> the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-
09
> = 7 workdays)
>
> I hope I have explained this ok!
> Thank you for any direction.
>
> Ken
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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



[Non-text portions of this message have been removed]
9
> The piece I cannot figure out is how to get the number of workdays
> in the selected date range (we only work Mon-Fri) (IE: 1-12-09 / 1-20-
> 09 > = 7 workdays)

A Google search provides:
http://www.kenhamady.com/form01.shtml