About this software
Percent is a built-in calculation function in IBM Cognos Analytics that returns a value's percentage of the total for selected data items. It evaluates numeric expressions and supports formatting as a ratio or a percentage for display.
Report authors and analysts use it to show proportional contributions in dashboards, crosstabs, and reports without manual calculations. Syntax follows percent(numeric_expression) as documented by IBM.
Purchase
IBM Percentage Of
In Stock
Delivery: 1 working day
Loading...
€134.44
Free and without obligation
Do you need more information or looking for another license?
Benefits
- Percent-of-total calculation: Calculates each value's share of the total automatically in reports
- Works with numeric expressions: Accepts numeric expressions as input using percent(numeric_expression) syntax
- Formatting options available: Can display results as a ratio or as a formatted percentage
- Useful for dashboards and reports: Shows proportional contributions in dashboards, crosstabs, and list reports
- Reduces manual calculations: Removes need for external spreadsheet calculations inside report definitions
Available languages
- English
Support information
- Product documentation: IBM Cognos Analytics documentation includes function references and examples for percent calculations.
- Knowledge base articles: IBM Support portal contains troubleshooting articles and technical notes about percentage calculations.
- Community forums: IBM Community for Business Analytics hosts user questions, examples, and implementation advice.
- Training and videos: IBM provides tutorials and video learning materials for Cognos Analytics report authors.
- Developer documentation: Function syntax and usage examples are available in the Cognos Analytics function reference.
Frequently asked questions
What does the Percent function do in Cognos Analytics?
Returns the percentage of the total value for selected data items; users can format results as ratios or percentages.
How do I use the Percent function with measures?
Invoke percent(numeric_expression) where numeric_expression is a measure or calculation; the function computes each item's share of the total during aggregation.
Can the Percent function be formatted as a ratio?
Yes; IBM documentation notes results can display as a ratio (for example .25) or as a percentage (25%).
Which IBM product includes the Percent function?
The Percent function is documented within IBM Cognos Analytics function reference and used in Cognos reporting components.
How can I calculate percentage of a current measure on a tuple?
IBM support shows two approaches: use a constant denominator or compute a changing denominator with tuple expressions in Report Studio.