Troubleshooting
Problem
When users create an arithmetic calculation in workspace , not all cells calculate.
Select 2 elements displayed in the column, then right click to select Create Calculation, then select the Arithmetic option to subtract one element from the other. Some cells calculate, others are blank.
Cause
Issue could be related to underlying value or length itself compared to the working cells that does display fine.
Resolving The Problem
To resolve the issue,
1. Right click the calculated column (with the missing values)
2.Select Set Format
3.Select Rounded.
This will show all the values
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000GoxTAAS","label":"1 - Migrated Categories-\u003EBA - Planning Analytics Cloud-\u003ETroubleshooting-\u003EPlanning Analytics Workspace"}],"ARM Case Number":"TS005916127","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
13 December 2021
UID
ibm16525844