Recent content by TMcCrillis

I have several .plt files that have been converted to PDF and then placed into a PM7 document. Everything prints great on an office laser. Looks great on screen. Sent to the printers and they bring back a proof with 20 pages (out of 48) with "ghosted" images. They are there, but so light you...

Changing the formula per your suggestion, to: //{@diff} to be placed in the detail section: whileprintingrecords; numbervar add; numbervar diff := datediff("d", {V_ITEM_HISTORY.DATE_HISTORY}, next({V_ITEM_HISTORY.DATE_HISTORY})); if {V_ITEM_HISTORY.CODE_TRANSACTION} = 'J52' and...

Average works fine thank you!- however I need to account for the built to order parts which have a day count of 0-2 days. So what I'm looking to do is have a set of results which contain 9 serial numbers, with the following results 8,7,7,7,0,0,17,14,25 for number of days on shelf (@diff)from...

Thank you for your help. I appreciate it. It was not my intention to "waste everyone's time". As I mentioned, I'm very new to this and am fighting my way through as I go.

//{@diff} to be placed in the detail section: whileprintingrecords; numbervar add; numbervar diff := datediff("d", {V_ITEM_HISTORY.DATE_HISTORY}, next({V_ITEM_HISTORY.DATE_HISTORY})); if {V_ITEM_HISTORY.CODE_TRANSACTION} = 'J52' and {V_ITEM_HISTORY.SERIAL_NUMBER} =...

I can't use a running total because the data that I need to pull the adjusted average from is not stored in a table. It is part of another formula. Can I still use a running total?

Thanks for the info. I can't exclude the records because I still need them for the subreport...I need to see all records for a serial number when the subreport(on demand) is opened.

I'd like to create an average in Crystal 8.5 however, I need the calculate to exclude any quantity of 0 or 1 from the average. Part Days 1A 20 1A 37 1A 5 1A 1 1A 0 1A 3 I have an average calculated already which would give me an average of...

Thank you so much for your help. I really appreciate it. If I could ask one more question, how can I get an average days on shelf for each part number. I tried: Average ({@diff}) ...which didn't work. Thanks again!

if {V_ITEM_HISTORY.CODE_TRANSACTION} = 1 and {V_ITEM_HISTORY.SERIAL_NUMBER} = next({V_ITEM_HISTORY.SERIAL_NUMBER}) then add := add + diff else if {V_ITEM_HISTORY.SERIAL_NUMBER} <> next({V_ITEM_HISTORY.SERIAL_NUMBER}) and {V_ITEM_HISTORY.CODE_TRANSACTION} = 1 then add := add +...

Part_Number (from Main Report) 115TL20 Serial_Number Date_History CODE_TRANSACTION 44586 04/26/2006 J52 (On Shelf) 44586 05/10/2006 J55 (Off Shelf) 54423 08/21/2006 J52 56871 09/25/2006 J52 56872...

I'm new to crystal and know what I do only by "hands on", what I've figured out on my own... so be gentle.... I'm trying to calculate the # Days a product was on the shelf. I have records from the same table that I need to calculate and I don't have the first idea how. I've created the main...