What sort of details? Here's the help text if you haven't read it. I'm not sure what else I can provide.
sum( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ] expression )
Returns the aggregated sum of expression or field iterated over the chart dimension(s).
Examples:
sum( Sales ) | |
sum( Price*Quantity ) | |
sum( distinct Price ) | |
sum( Sales ) / sum( total Sales ) | returns sales within the selection. |
sum( Sales ) / sum( total <Month> Sales ) | returns sales within the selection for each Month |
sum( Sales ) / sum( total <Month,Grp> Sales ) | returns sales within the selection for each Month and Grp |
sum( Sales ) / sum( {1} totalSales ) | returns sales within the entire document. |
sum( {BM01} Sales ) | returns sales within the selection defined by bookmark BM01. |
sum({$<Year={2007,2008}>}Sales) | returns the sales for the current selection but just for year 2007 and 2008, i.e. the same as Sum(if(Year=2007 or Year=2008,Sales)) |
count( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ]expression)
Returns the aggregated total count of values from expression or field iterated over the chart dimension(s).
For this function it is allowed to use the distinct qualifier in combination with the total qualifier This combination is not valid for any other aggregation functions.
Examples:
count( Sales ) | |
count( Price*Quantity ) | |
count( distinct Price ) | |
Count( Alpha ) / Count ( Distinct Total Alpha) | |
count( Sales ) / count( total Sales ) | returns sales within selection. |
