4 Replies Latest reply on Apr 6, 2016 12:41 AM by Vivian Perceval

    Formula to display entry type as a proportion of the total

    Vivian Perceval

      I have a column in a spreadsheet entitled "feedback" with either negative or positive listed. Displaying a count of this appears fine, but the following formula returns 0 for every entry:

       

      count( if [feedback] = "positive" then 1 else null end)/count([feedback])

       

      I am trying to display the count of positive feedback as a proportion of the whole.

       

      I'm predicting the issue is something very simple in the syntax I'm using but I can't see what... Any help?