groupByAggregate - APEXlang Reference

`groupByAggregate`

Parent: savedReport

Applies whengroupBy = true

Direct Properties:

Property	Type	Required	Default Value	Details
`heading`	`string`	No		data type=`string`; maxLen=4000

Property Groups:

aggregate

Property	Type	Required	Default Value	Details
`function`	`enum`	Yes	`sum`	data type=`string`; lov=`STATIC` Valid values: `sum` `average` `max` `min` `median` `count` `countDistinct` `percentOfTotalSum` `percentOfTotalCount`
`column`	`string`	Yes		data type=`string`; maxLen=128
`column`	`string`	No		data type=`string`; maxLen=128 Applies when`function in (count)function in (countDistinct)function in (percentOfTotalCount)`
`displaySum`	`boolean`	Yes	`false`	data type=`boolean`

aggregate {
  function: sum
  column: value
  displaySum: false
}

appearance

Property	Type	Required	Default Value	Details
`formatMask`	`string`	No		data type=`string`; maxLen=255

appearance {
  formatMask: value
}

layout

Property	Type	Required	Default Value	Details
`sequence`	`integer`	Yes		data type=`integer`; maxLen=32767

layout {
  sequence: 42
}

APEXlang Example

groupByAggregate sample (
    heading: value
    aggregate {
        function: sum
        column: value
        displaySum: false
    }
    appearance {
        formatMask: value
    }
    layout {
        sequence: 42
    }
)