I'm pretty sure this is a easy issue, but I'm banging my head trying to figure this out. Any help would be greatly appreciated. Here's my scenario:
I have a large application that that has a summary page in a list format with financial information. On this page, there are group names and the summed finances for that grouping (ie.Capital and Expense). Creating this part was easy. That was up until they wanted a sum of the already summed items in the footer section.
An example of this would be show all the financials for this year. The user would perform a search for the year and all the years groupings would appear in the list which also shows the summary of each of those groupings on the same line. I now want a grand summary in the footer section that would show the totals for all.
I created and attached a very rough example of what I am trying to achieve. (Note: I am using FM12)
I'm hoping this is a simple solution, but I am just not seeing it for this.
Thanks in advance !!