5 Replies Latest reply on Mar 7, 2013 8:53 AM by philmodjunk

    sum up values of non-unique entries sort by the entries itself

    PhilippEffenberger

      Title

      sum up values of non-unique entries sort by the entries itself

      Post

           hej folks,

           after quite some trial and error i now turn to you to ask how to solve this issue:

           i got a Session database, that saves hours spent in a specific kind of therapy sessions. the session contains a client_ID that links to the client table, a session_kind field describing the kind of sessions (group session, single session) and a hours_spent field describing how many hours a customer spent in the different sessions. [example below]

           i have a summary and calculation field in the session table:

      Summary field: total_of_hours sorted according to kind of hours [running total and restart summary for each group]
      Calculation field: GetSummary ( summary_field ; kind_of_session )

           the calculation works out, however due to the total running option it is not only the final total displayed but also the intermediate calcualtions. how can i get rid of the intermediate calculations and only display the final total? where is my error?

           

                WHAT I WANT: 

           

      [client] [id] [session kind] [duration]
      Peter 123 group-session 4hrs
                Peter 123 group-session 2hrs
                Steve 2 single-session 1hr
                Steve 2 single-session 2hs
                Steve 2 group-session 2hr

           

                and i'd need a layout, that gives me a distinct listing of session_kind per client and the total value of duration per each session:

           

      Peter 123 group-session 6hrs
                Steve 2 single-session 3hr
                Steve 2 group-session 2hr

           

                WHAT I GET:

           

      Peter 123 group-session 4hrs
      Peter 123 group-session 6hrs
      Steve 2 single-session 1hr
      Steve 2 single-session 3hr
      Steve 2 group-session 2hr

           thanks in advance!