6 Replies Latest reply on Nov 4, 2013 12:14 PM by Pei-Zhen Yu

    Calculate AVG of number-looking aliases of a String field

    Pei-Zhen Yu



      As in the attached mock-up, I am trying to calculate the average of 'Answers'. 'Answers' is a String field. And I have created aliases for different ratings"Bad, Okay, Good, Great" as in below screenshot.

      Is there a way show the average of the aliases? (In other words, the average of column 'Answers' excluding the text answers)


      Thanks much for your time!!