tomlepk Posted June 27, 2001 Share Posted June 27, 2001 I have a database with 'item', 'run name', 'tags run' and 'time'. I also have a calculation for tags per hour(tags run/time)unstored. I have 2 summary fields for total 'tags run SUM' and 'time SUM' these summary fields show the correct data. But if I create a field called 'labels per hour SUM' and make it a calculation of (tags run SUM / time SUM) the result is for the entire found set, what I want is for the individual items to have their own totals, what do I do? I have the database sorted by 'item', then 'run name' and I have the report parted out as header,sub sum item,sub sum run name,sub sum item,footer. The 'labels per hour SUM' is in the last sub sum item. Every 'item' has anywhere from 1 to ... 'run names' i just want a run rate summary of those items not for the entire found set. (I used underscores instead of spaces to simulate a fixed character width) ITEM ___RUN NAME_________TAGS RUN____TIME________LABELS PER HOUR FT1291C ___FT1291C730613_______49_______2.58_________18.992 ___FT1291C730613-0_____41_______2.42_________16.942 ___FT1291C730613-1_____16________.9__________17.778 SUMMARY OF FT1291C___106_______5.90_________22.776 (should be 17.966) FX1001C ___FX1001C730608_______25_______1.14_________21.930 ___FX1001C730608-0_____18________.59_________30.508 SUMMARY OF FX1001C____43_______1.73_________22.776 (should be 24.855) Now that 22.776 is the calculation of entire found set, not from that individual line in my report how do I fix that. Thanx in advance. Thomas Lepkowski Link to comment Share on other sites More sharing options...
LiveOak Posted June 27, 2001 Share Posted June 27, 2001 When performing calculation with values from Summary fields, you must use the Get Summary (field, break field) to extract the summary value you wish to use. Your calculation should look like: labels per hour SUM (calculation, number) = Get Summary (tags run SUM, Item) / Get Summary (time SUM, Item) If you want an overall average in a Trailing Grand Summary part, you should still use the Get Summary function any time you are performing a calculation on a summary field, but now is will look like: Get Summary (tags run SUM, tags run SUM) / Get Summary (time SUM, time SUM) Again the key is that you MUST use a Get Summary() function when creating a calculation using a summary field. -bd Link to comment Share on other sites More sharing options...
tomlepk Posted June 27, 2001 Author Share Posted June 27, 2001 Thank you sooo much! I have a bald spot from tugging out tufts of hair over this. Thomas Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8362 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now