property Items.ComputeValue ([Expression as Variant], [Item as Variant], [ColIndex as Variant], [ValueFormatType as Variant]) as Variant
Computes the value of a specified formula.

TypeDescription
Expression as Variant A string expression that specifies the formula to compute
Item as Variant A long expression that specifies the handle of the item.
ColIndex as Variant A long expression that indicates the column's index, a string expression that indicates the column's key or the column's caption.
ValueFormatType as Variant A ValueFormatType expression that indicates the type of the formula being interpreted by the Expression parameter. For instance, if the ValueFormatType parameter is exTotalField, the Expression parameter should inidcate a total formula of type aggregate(list,direction,formula) 
Variant A string expression that indicates the result. 
The ComputeValue property gets the result of a a computed or total field. The Item and ColIndex property refers the cells used as the source for the formula. Use the ComputeValue property to get the result of a total field. For instance, for a total field, the CellValue property indicates the formula, while the ComputeValue can be used to get the result of the formula at runtime.

The ComputeValue method returns the:

For instance, based on the ValueFormatType and Expression parameters the result could be: