4 Replies Latest reply on Apr 13, 2018 11:53 AM by Suzanne Heino

    Sum function providing inconsistent values

    Suzanne Heino

      Hi all, I'm curious if you can help me!

       

      I am trying to get a total number of participants in a session, average number of participants per session and total number of sessions. While some of the calculations work, some are throwing a completely incorrect number.

       

      I've tried different joins between the tables, different types of calculations such as total and sum. I've attached a workbook with more details.

       

      I greatly appreciate any thoughts you might have!

      Thanks in advance.