EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB39182: Nested numeric calculations are not validated when creating a consolidation thus creating incorrect formulas in Developer 9.x and 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


Nested numeric calculations are not validated when creating a consolidation thus creating incorrect formulas in Developer 9.x and 10.x

SYMPTOM:
When validating a consolidation arranged such that 0-, the equation is re-arranged such that making the formula invalid.
 
Consider a consolidation using a nested formula as the one show in the screenshot below:
 

ka044000000kLg1AAE_0EM440000002DMZ.png

Sample Code/Error
Formula: 0 -  
   
 
After clicking the "Validate" button, the consolidation formula gets rearranged as shown below: 
 

ka044000000kLg1AAE_0EM440000002DMY.png

 
 
 
 
 
 
 
 
 
 CAUSE:
This is a known issue in Strategy Developer 9.x and 10.x.
 
ACTION:
Contact Strategy Technical Support for an update on the status of this issue.  
 
WORKAROUND:
To resolve this issue, eliminate nesting in calculation by distributing the negative sign to the appropriate components as shown below: 
 

ka044000000kLg1AAE_0EM440000002DMl.png

 
Sample Code/Error
Formula: (y-x-z)
 
 
 
 
 
 
Sample Code/Error
Formula:  
 
KB39182


Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

December 31, 2018