Calculate Sum of Numbers from Text Fields

[gerda.grantina]

Hi @Albert_Manuel ,
You may want to check this solution and see if that works for you:

Calcualted Measure with a Custom Field - 'Short Text'

Hi @Vivek_Rajan, if the custom field type is text and you use it for holding numeric values, eazyBI still perceives field values as text. You can create a calculated measure in the Measures section and transform the sting of numbers to a numeric format. Use function Cast() to change the data type to numeric and function ExtractString() to correctly process values that are texts or contain some white spaces or other symbols by mistake (data are not always so clear as we think they are). The ex…

best,
Gerda // support@eazybi.com