You can just make a calculation field that adds the two summary fields together. Make sure it is unstored. Alternatively you can do almost any summary calculation with ExecuteSQL.
To pull out summary data you need to use the GetSummary ( ) function. This enables you to grab the contents of an instance of a Summary field and use it elsewhere in your solution.
1 of 1 people found this helpful
Both previous posts give an answer that is correct, but in different contexts. When you set up a calculation field such as:
SummaryField1 + SummaryField2
You get the sum of two "grand totals" as calculated over the entire found set. This might be what you want if you want to show a calculated value in a grand summary layout part.
On the other hand:
GetSummary ( summaryfield1 ; breakFielda ) + GetSummary ( SummaryField2 ; breakFielda )
enables you to calculate using the subtotals that you might see in a sub summary layout part where "breakFielda" would be the "sorted by" field that you specify for the sub summary layout part.
Thanks, Phil. It worked! Great explanation.