Using Sum and Count Data Sources in Formulas

Data Source values are retrieved (accessed) in forumlas using the LOOKUP() function,.

Since LOOKUP() functions simply return values, they can be combined in more complex formulas.  For example, this combination calculates a percentage by dividing two the values returned by two LOOKUP() functions:

= Format(ParseDecimal(LOOKUP(UnitPriceSumQuery1, EmployeeID)) / ParseDecimal(LOOKUP(UnitPriceSumQuery,"")), "p")

PARSEDECIMAL and FORMAT are needed because LOOKUP returns either a string or an object.  PARSEDECIMAL converts the values returned by LOOKUP into numbers, and FORMAT converts the percentage into a displayable string.

See Also

Configuring Dashboards with the Sums and Counts Wizard