Subject:substring-before and sums Author:James Delaney Date:19 Jan 2010 04:39 PM Originally Posted: 19 Jan 2010 04:37 PM
I have a simple problem that I haven't been able to figure out. I'm sure that I'm not applying something correct that you all may be easy to spot quickly:
I have a list of ages that have numerical and string data. I need to find the average age among the list. I can convert the data rows into numerical formats, but when I try to do calculations on it (like sum) it's returning an error (Input to sum() contains a value that is neither numeric, nor a duration).
Subject:substring-before and sums Author:Tony Lavinio Date:25 Jan 2010 02:15 PM
Your expression is still including the space after the number - you only trimmed off the text from the '(' forward. Try removing that space. There is also a number() function that can coerce a string to a number.
Subject:substring-before and sums Author:James Delaney Date:25 Jan 2010 02:53 PM
Hello Mr. Lavinio,
Thank you for the response. I have attempted to strip the space and the same issue with the sum/number is occurring. Also, without any modification of the string, a number() seems to always result in NaN.
May you have any other suggestions? Thank you again for your assistance.