Symptom
• When a Calculated Column with a long formula is added in Query Designer, the display keeps reverting to one line, making it difficult to read.
• Users may seek a way to reformat or display the formula in a more readable format within the visible area of the text box.
Environment
- SAP SuccessFactors
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Stories in People Analytics
- Query Designer - Filter, Calculated Column, Params
- Stories in People Analytics
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
- Log in to the Report Center.
- Open an existing Story or create a new Story.
- Navigate to the Query Designer.
- Add a Calculated Column with a long formula that exceeds the visible area of the text box.
Resolution
In the Calculated Columns tab, a user can highlight the formula and then click on Format to have the editor reformat the single line into multiple ordered and more readable line.
1. Highlight or select all text of the entire formula, which is displayed in a single line
2. Click on Format button.
Keywords
long formula, calculated column, reformat, formatting, story editor, query designer, formula editor, text box, visible area, multi line format, readability, SAP SuccessFactors, People Analytics, Query Designer, calculated fields, formula display, formula readability, editor formatting, text box adjustment, calculated column formula, query designer usability, SAP analytics, formula reorganization, visible text area, formula editing, story report , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To
Product
Attachments
| Pasted image.png |
SAP Knowledge Base Article - Public