Convert and Calculate: Strings to Numbers and Numbers to Strings

In SAP Analytics Cloud, convert a string value to a numeric value or a numeric value to a string value and use the new values in calculated dimensions or measures.

There are two functions that you can use to convert values from one type to another in calculated measures or calculated dimensions: ToNumber and ToText.

ToNumber converts string values to numbers
ToText converts numeric values to strings

ToText uses an existing calculated dimension in its calculations.

ToNumber Function

In Builder, under Dimensions, select Add Dimension Calculated Dimensions.
In the Calculation Editor under Type, select Calculated Dimension.
Create your formula.

Example
ToNumber ([d/ACT_EMPLOYEE_NUMERIC:Age_String].[p/ID])

ToText Function

ToText requires an existing calculated dimension.

In Builder, under Dimensions, select Add Dimension Calculated Dimensions.
In the Calculation Editor under Type, select Calculated Dimension.
Create your formula.

Example
ToText (<ToNumber calculated dimension> ) + " years"

Dimension to Measure

The string and number conversion functions can be combined with Measure-Based dimensions (in a calculated dimension) to create measure to dimension conversions. For more information about Measure-Based dimensions, see Create Measure-Based Dimensions.

There is also a calculation type that lets you convert a dimension to a measure.

Add a chart to the canvas.
In Builder, choose Add Measure Create Calculation Dimension To Measure.
From Dimension Attribute to Convert, select a dimension.
Select context dimensions.
Set the aggregation operation type.
Select OK and review the results in the chart.