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
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.