Sum of all-numeric values in text field Easy BI

Questions & Answers
, ,
1

Hello,

How do I calculate the sum of all the numeric values in the text field by eliminating non-numeric values?

I have converted the numeric value still I am not getting the sum. Your help is much appreciated.

image
image798×722 111 KB

Thanks a lot.

Theja

2

Hi @theja.85

Thanks for posting your question!
You could try formula below and check if it returns the expected results. I’m using the Descendants (Descendants) function in formula below that allows to iterate through every issue and sum-up all the numeric values.

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues created]>0 AND
   NOT IsEmpty([Measures].[Issue CR overall effort])
  ),
cast(
  --extract only the number from the text if it has any
  ExtractString(
    [Measures].[Measures].[Issue CR overall effort],
    "(\d+)",
    1)
  --convert an extracted numeric value to a numeric data type
  AS NUMERIC) )

Best wishes,

Elita from support@eazybi.com

1 Like
3

Thank you Elita. Its working…

1 Like