IBM Accelerator Catalog
IBM Accelerator Catalog

How to calculate the percent change from one row to the next in a List

This document will demonstrate how to add a new column to a List that calculates the percent change from one row to the next using the running-difference function.

Slide Two

About this accelerator

Version: Cognos Analytics 11.2.0 to Current

Suppose you have some monthly data for units sold in a list in a report. You would like to know what the percent change in units sold from January to February was, and from February to March, and so on. This guide will demonstrate how to add a new calculated column to the list that uses the running-difference function and a percent change calculation.

Additional details

  • Accelerator typeHow to
  • IndustryAny
  • Business functionAny
  • Product and version Cognos Analytics - 11.2.0 to Current
  • Author typeIBM
  • Company nameIBM
  • Author name IBM
  • Last modifiedMay 19th, 2021
  • Language English