Margins on a sales report Totaling

There is not currently a way to do math between totals on a summary report or on totals on a table report.  You would need to get those totals accumulated up to a parent record and then do the math there.  The issue of course is that you need to plan out what totals you need to accumulate and set up the Parent table records. 

For example if you just wanted monthly totals with Margins, you would need to load up a table of months where the Key field is the first of each month and then make a relationship down to the detail tables and roll up the total sales and total costs up to that record, then do proper margin calculations up there.

mnark

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------