3248705 - How to remove spaces between words in a column? - Story report [People Analytics]

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 HXM Suite
• People Analytics

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.

People Analytics, 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