Symptom
In the field definition for the "achievement" Metric Lookup Table Column, the field-format is not being respected and only returns values to 5 decimal places.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Goal Management
Reproducing the Issue
In the Goal Plan XML template, the field-format for the "achievement" table column is defined with more than 5 decimal places (example below shows 9 decimal places):
When adding a goal in the Goal Plan, it is possible to add values with the 9 decimal places:
In the Goal Plan, the "achievement" table column only returns the value entered to 5 decimal places:
Resolution
- As defined in the database, the max length for the achievement column is 38 and the supported decimal places is 5 (38,5).
- Thus, the current system behaviour is that the "achievement" table column which is of field type "number" will only display 5 decimal places.
Workaround:
- If the customer wishes to calculate with larger values, they may rely on the default thousand separators.
- The field-format attribute should be removed from the field-definition of the "achievement" table column.
- By default, values entered will display with thousand separators:
- We encourage you to submit or vote on an enhancement request to have this functionality considered within future development cycles – you can do this on our Customer Influence Portal at https://influence.sap.com/successfactors .
- All enhancement requests are reviewed by our Product Management team and, if successful, are developed and implemented in a future product release.
- Peer voting is a key part of this review process, so we encourage you to provide a clear explanation so that other customers are able to understand the functionality requested.
Keywords
TGM, GM, Goal Management, Objective, Metric Lookup Table, MLT, Achievement, table column, field-format, format, definition, decimal places, not respecting, dropping, zeros, hash, database, TGM-3873, personal, user, group, team goal, add, create, view goal details, audit, history, database , KBA , LOD-SF-GM , Goal Management , Problem