1 Reply Latest reply on Oct 4, 2013 9:11 AM by Matt Lutton

    Calculate Average of a string field

    Dan DiVito
      Hello everyone,
      I have a field that is mostly numerical, but can also have text in it, for comments.  I have filtered out only the data that I need.  I have to perform average calculations on this field.  Because the field has both numerical and string values in it, if I change the value field data type to numerical, it will properly average the scores, but will leave out the comments, obviously because it is not a number.  If I change the data type to string, the comments are there, but it will not calculate the average.
      Is there a way to parse out this data within a single field so that I can average the numbers that I need, while keeping in the comments?

      Show trimmed content