Views:

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

NameTypeDescriptionRequired
keyxxxxxxxxxxxx
expressionxxxxxxxxxxxx
filterxxxxxxxxxxxx
defaultvaluexxxxxxxxxxxx

Notes: