Calculate Sum of Numbers from Text Fields

[Albert_Manuel]

Hi,
I hope I can get some help here because I’m stuck.

We have 2 custom fields (text type) where people add numbers - they chose to do it like that a long time ago because of the comma Jira is adding in their number fields.
Now I’m required to create somehow a report where I need to sum 2 text fields (they have numbers in it, only numbers).

Is there any way to calculate them in eazybi?

[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