This seems simple enough, but nothing I've tried with Global Math and Aggregation works.
I have a table of records. Each record has a sell price value and a quantity value. I want to multiply the sell price by the quantity, and sum the results to get total sales.
How is this done? All my experiments with grouping, summing, and math give the wrong answer.
Note: I'm grouping on some text fields, and each group should have a separate total sales number.