Chef Roy Posted September 17, 2016 Share Posted September 17, 2016 (edited) I have a food inventory database that has a month-end final report food-type category as it relates to how they are expensed in my accounting system e.g. Food 5001, Beverage 5002, Vending 5010, etc, etc. There are 12 expense categories altogether accessed by a Popup Menu. The month-end report has a Sub Summary field “CategorySubtotal” that provides a department total value based on a sort by the Category food-type field. Works very well as a printed report however, once my chef confirms that the report is an official end of month reporting of his inventory I am having a hard time determining how to save each of those sub summary amounts to variables for the purpose saving to another table. The table is then used to develop month-end food cost and asset adjustments. I am a chef business owner and totally into FileMaker, though this one has me stumped! Any assistance would be appreciated. Chef Roy Edited September 18, 2016 by Chef Roy To highlite headings Link to comment Share on other sites More sharing options...
comment Posted September 18, 2016 Share Posted September 18, 2016 6 hours ago, Chef Roy said: how to save each of those sub summary amounts to variables for the purpose saving to another table. Do a search for a technique known as Fast Summaries. Another option is to define a calculation field as = GetSummary ( sTotalCost ; Category ) then export the data grouped by Category. Link to comment Share on other sites More sharing options...
Chef Roy Posted September 18, 2016 Author Share Posted September 18, 2016 Sorry, may have misrepresented what I was looking for, unless I just cannot seem to fathom it out. The Fast Summaries as I understand them relate to extracting counts based on a search criterion, but all I need are the individual SubSummary headings and their subtotals (highlighted above) saved to either a variable or field for further processing. Link to comment Share on other sites More sharing options...
comment Posted September 18, 2016 Share Posted September 18, 2016 5 minutes ago, Chef Roy said: The Fast Summaries as I understand them relate to extracting counts based on a search criterion, No, the technique is designed to go over any sorted found set and get the sub-summary values (the numbers in red in your screenshot). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2904 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