AnsweredAssumed Answered

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

Question asked by PhilippEffenberger on Mar 7, 2013
Latest reply on Mar 7, 2013 by philmodjunk

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!

Outcomes