IBM Support

Values of distributed leaf cells are different the second time a spread operation is performed (triggered by leaf cell's original values being zero) - relating to ProportionSpreadToZeroCells

Troubleshooting


Problem

Customer has a 'consolidated' cell (at the top), with several 'leaf' cells below it.
User types in a value inside the consolidated call, and presses <return>.
  • This causes values to be 'spread' to the leaf (child / daughter') cells below.
User then repeats the exact same task (typing in the same value inside the same consolidated call, and presses <return>.
  • This causes different values to be spread to the leaf cells.

Symptom

Imagine a scenario where:
  • Initially, all the leaf values (highlighted inside blue box below) are set to zero (o)
  • User types in a value (0.03) inside the consolidated call (highlighted in pink box below):
image-20190611070023-1
After user presses <enter> the consolidated and leaf cell values change (to 0.25%) as shown below:
image-20190611070318-2
However, if the end user repeats exactly what they did before (typing in 0.03 into that pink box again)...
image-20190611070557-3
...then when they press <enter> the values of the leaves change to a different value:
image-20190611070843-4
The above values are what the users expected.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
11 June 2019

UID

ibm10887299

Page Feedback