Hello,

This is likely a dumb question but is there a way to do calculations/formulas on totals on saved searches?

For example, my search looks at transactions for a month.  I get sell price and cost for every line item sold that month.  I total these columns and then want to calculate profit margin on those sums. 

I can calculate profit margin for each line but there is no accurate way to show the margin for the summary (average, sum etc. are all inaccurate for the total).

Thanks all.