In the group and report footer I have a table of values in a structured tabular layout. There are 5 rows - sum of cost for Type 1, 2, 3, 4 and 5. I used sum(iif([type]=1,[Type1_Cost),0)) etc and I used this formula for in each of the 5 rows for each of the columns I want to sum. It formats and looks ok however for each report section the costs are typically of only one type and so I end up with 3 or 4 zero rows in each footer section. Simple illustration below.
I would prefer if possible to provide the summary totals only for the cost types that exist in that section. Total cost is always the first row. In the footer section example below I would like to see the total Cost, Type 2 and Type 4 rows only. What are my options please.
thanks
I would prefer if possible to provide the summary totals only for the cost types that exist in that section. Total cost is always the first row. In the footer section example below I would like to see the total Cost, Type 2 and Type 4 rows only. What are my options please.
thanks
Budget Cost | Actual Cost | Projected Cost | Variance | |
Total Cost | 10 | 16 | 20 | 10 |
Type 1 | ||||
Type 2 | 5 | 12 | 5 | 0 |
Type 3 | ||||
Type 4 | 5 | 4 | 8 | 3 |
Type 5 |
Last edited: