SAP Knowledge Base Article - Public

3377024 - How to format a long Calculated Column formula line in Story People Analytics


When a Calculated Column with a long formula is added in Query Designer, the display keeps reverting to one line which makes it very difficult  to read

Is there a way to easily reformat or display the formula into a more readable text within the visible area of the text box?


SAP SuccessFactors People Analytics

Reproducing the Issue

1. Login and go to Report Center

2. Edit an existing Story or create a new Story

3. In the query designer add a Calculated Column with a long formula which spans beyond visible area of the text box.


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 


long formula, calculated column, reformat, formatting, story editor, query designer , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To


SAP SuccessFactors HXM Core 2305