3248705 - How to remove spaces between words in a column? - Story reports

How to remove space between 2 words in a column?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors HCM Suite
  • Analytics & Reporting  (Ad Hoc, YouCalc, ORD)
    • Story reports
      • Query Designer - Filter, Calculated Column, Params

We can do that by using a calculated column with the following formula:

REPLACE(COLUMN_NAME," ","")

Note: This is not possible in Table or Canvas reports.

https://help.sap.com/docs/successfactors-platform/story-reports/formula-functions-in-calculated-columns-for-sap-analytics-cloud-stories?locale=en-US&version=LATEST

Story Report, Space, Spaces, Blank, Words, Word, Columns, Fields, Calculated Column, Formula, Replace, Table, Canvas, Detailed, Advanced, Adhoc, Ad Hoc , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To