Durango122
MIS
Hi Folks
ms sql
cr 9.0
i have a report that has a {?End-date} that i used as my parameter.
i need some help on how to calculated Sales Daily YTD Avg
keeping in mind they want working days with are monday to friday and holidays.
my date field is
{Transaction_History.Posting_Date}
to calculated my daily sales i used this formula
----------------------------------
@Daily_Sales
if {TRANSACTION_HISTORY.POSTING_DATE} <= {?End_Date}
and
{TRANSACTION_HISTORY.TRADE_CLASS} = "S"
then
round({TRANSACTION_HISTORY.GROSS_AMOUNT})
else
0
---------------------------------------
the holidays days are
2007 Holiday Schedule
New Year's Day Monday, January 1
Martin Luther King, Jr. Day Monday, January 15
President's Day Monday, February 19
Good Friday Friday, April 6
Memorial Day Monday, May 28
Independence Day Wednesday, July 4
Labor Day Monday, September 3
Thanksgiving Day Thursday, November 22
Christmas Day Tuesday, December 25
Can someone help me out on this one
and if possible some example on the coding would be appreciated
Thanks
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
ms sql
cr 9.0
i have a report that has a {?End-date} that i used as my parameter.
i need some help on how to calculated Sales Daily YTD Avg
keeping in mind they want working days with are monday to friday and holidays.
my date field is
{Transaction_History.Posting_Date}
to calculated my daily sales i used this formula
----------------------------------
@Daily_Sales
if {TRANSACTION_HISTORY.POSTING_DATE} <= {?End_Date}
and
{TRANSACTION_HISTORY.TRADE_CLASS} = "S"
then
round({TRANSACTION_HISTORY.GROSS_AMOUNT})
else
0
---------------------------------------
the holidays days are
2007 Holiday Schedule
New Year's Day Monday, January 1
Martin Luther King, Jr. Day Monday, January 15
President's Day Monday, February 19
Good Friday Friday, April 6
Memorial Day Monday, May 28
Independence Day Wednesday, July 4
Labor Day Monday, September 3
Thanksgiving Day Thursday, November 22
Christmas Day Tuesday, December 25
Can someone help me out on this one
and if possible some example on the coding would be appreciated
Thanks
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40