SAP Knowledge Base Article - Public

3377024 - How to format a long Calculated Column formula line in SuccessFactors - Story report

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

Reproducing the Issue

  1. Log in to the Report Center. 
  2. Open an existing Story or create a new Story. 
  3. Navigate to the Query Designer. 
  4. 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

SAP SuccessFactors HXM Core 2305

Attachments

Pasted image.png