2 Replies Latest reply on Apr 23, 2015 2:18 PM by Christian Guerrero

    Can I divide values across multiple rows by a single value referenced else on the table?

    Christian Guerrero

      Hi,

       

      Hopefully the question makes some sort of sense. It's best if I explain with the below table:

       

      ReasonAttendedCompletedNot Completed% Not Completed

      N/A

      1008000%
      Not Home10555%
      Cancelled2051515%

       

       

      How do I create a calculated field so that the under the header "% Not Completed" I get the values I've put in the table?

      Essentially, the maths is simple, I'm just dividing the Not Completed value for each row by the Attended value next to reason "N/A" (100)

       

      I can't seem to work it out. Is it even possible?