Forum Discussion

ScottErvin's avatar
ScottErvin
Qrew Cadet
8 years ago

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

I have two field one contains the customer Spend by line item the second is the amount of Savings in that same transaction.  The savings is not always the same % and in some cases there is no savings....
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
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.