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.