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 +...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.