How do I get the sum of column as a % of the sum of another column in a summary report?

At present, Quick Base does not support math operations against columns on a Summary report, although the question does come up pretty often on this forum.

Depending on your table structure it is sometimes possible to get around this limitation with another table where the data can be summarized up to, but I see in your case, that other table would need to have every possible combination of the Category Listing, the Spend Owner and the Month.

So if i had a duplicate table to the main one with all the same fields in it I could potentially get the % figure.  I assume that would be by adding a summary field in the master table relationship to the second table?  That is entirely possible because the data come from an upload and would not be too difficult.  

How would I set that up and how would I incorporate it into my reports?

You would need to upload a table with a concatenated field of the

Category Listing, the Spend Owner and the Month.  That field would be set to be the Key field of the table.


so like
Guaranted-TD-201801 
Guaranted-TD-201802
Guaranted-TD-201803
.
.
Guaranted-MRO-201801
Guaranted-MRO-201802
Guaranted-MRO-201803



Then  on the details table you would create that same field by formula and then use that field in a relationship to do the summaries of the total spend and total savings.

Then calculate your % up on the summary record.

Then look that % savings down to the details table.

Then shows that field in the summary report as an "Average".  Note that the left most column of the report for the grand total average will be not mathematically correct  and you will not be able to suppress it from the report.

The thought stuck me driving into work that you can make the summary table entries by making a summary report in your details table of the unique values for the concatenated string and then and exporting it to the summary table.

Then do the reporting all off the summary table.