sales ytd

[kris0517]

i had asked a question similar like this before and i still cant' get it to work! someone hold my hand please!
i want to get last year's sales ytd (01-02) compare them with this year's sales ytd. this year's sales ytd is not hard. i tried doing it as advice given using cdate formulas but my field is not a date formula, it is a number formula. how do i edit the record specifically to get sales ytd for may 13, 2001 to may 13, 2002? how do i a formula that can do date periods for a number formula?

thanks

 

[dgillz]

1) Create a date range parameter

2) Create 2 formulas to get this year and prior year sales:

This year
if {Table.Date} in {?DateRangeParm} then {Table.SalesAmount} else 0

Prior year
if {Table.Date} in dateadd(y,-1,minimum({?DateRangeParm)) to dateadd(y,-1,maximum({?DateRangeParm})) then {Table.SalesAmt} else 0

3) if your date is an 8 digit interger in a YYYYMMDD format, you will need to convert it to a real dare with the numbertodate() function.

Does that answer your questions? If not please post again.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[dgillz]

1) Create a date range parameter

2) Create 2 formulas to get this year and prior year sales:

This year
if {Table.Date} in {?DateRangeParm} then {Table.SalesAmount} else 0

Prior year
if {Table.Date} in dateadd(y,-1,minimum({?DateRangeParm)) to dateadd(y,-1,maximum({?DateRangeParm})) then {Table.SalesAmt} else 0

3) if your date is an 8 digit interger in a YYYYMMDD format, you will need to convert it to a real date with the numbertodate() function.

Does that answer your questions? If not please post again.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[kris0517]

dglillz thank you for your help on the last question i asked about sales year to date from may 13, 01-02 and may 13, 02-03. however, i don't know where i can find a table that is strictly a date, ie. {table.Date} and no table with strictly {table.SalesAmount}

everything with a date is connected to something else. Everything with a Sales amount is connected to something else..

does that make sense?
how does it break down in details. i just took a crash course so my crystal skills are phenomenal.

thanks!!!!