Description
Returns a calculated value from the local xCache collection based on an optional filter.
Signature
xCacheCalculateLocal('key', 'expression', 'filter', 'defaultvalue')
Example
xCacheCalculateLocal( 'Accounts', 'Sum(numberofemployees)', 'address1_city = "London" ', '0' ) Returns 2734
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| key | xxxx | xxxx | xxxx |
| expression | xxxx | xxxx | xxxx |
| filter | xxxx | xxxx | xxxx |
| defaultvalue | xxxx | xxxx | xxxx |