SAP Knowledge Base Article - Preview

3304995 - Error when converting a string field using ToNumber() function in Story report

Symptom

User is trying to convert a string field to number in query designer using ToNumber() function but gets "Internal error occurred while processing" error message when trying to preview the query. 

User is trying to convert a calculated dimension but receives the error message: "Formula could not be computed: Choose a property for dimension xxxx in function "ToNumber". Please complete or rewrite the formula."




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


Read more...

Environment

SAP SuccessFactors People Analytics

Product

SAP SuccessFactors HXM Core 2211

Keywords

Story query designer, ToNumber() function does not work, Error when creating calculated column, How to convert string field to number in Story, convert to number story, function, functions, calculation, editor, calculated, column, columns, month, tonumber, datasource, query, designer  , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.