Skip to Main Content
IBM Data and AI Ideas Portal for Customers

This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at

Status Not under consideration
Workspace Planning Analytics
Created by Guest
Created on Sep 7, 2021

Pafe should always display what is in the cube when doing a retrieve.

If a cube cell evalutes to #N/A due to a divide by zero error or circular reference then the following behaviour is observed.

In an exploration view in PAW the cell value is #N/A, correct!

In quick and exploration reports then cell displays as empty, somewhat OK.

In custom and dynamic reports cell values display as 0, failure.

Pafe has a simple job, display the data in the cube, it shouldn't be interpreting the results and recasting them.

Not seeing #N/A values in the standard most common reporting formats introduces significant risks of issues with the underlying rules or structure not being obvious.

Additionally it breaks a use case that is in play extensively in a large clients legacy TM1 budgeting application where a rule is used to set cell values to =1/0, this is used to generate an input mask for the end users so they can see very clearly where data entry is expected.

Please reinstate the legacy behaviour of the legacy formula based reporting such that they display #N/A accurately reflecting what is in the cube.

Needed By Yesterday (Let's go already!)
  • Admin
    Stuart King
    Aug 9, 2022

    This idea is not currently under consideration. The IBM Planning Analytics team may reevaluate this idea at a later date based on the number of votes it accumulates. The idea can still receive votes while not under consideration.

    PAfE will only support the unformatted value provided by TM1. This is for performance reasons. The TM1 database can only return null or a numeric value as the unformatted value for numeric cells.