AnsweredAssumed Answered

Getting self join sum working in sub summary report

Question asked by drdr2017 on Sep 28, 2017
Latest reply on Sep 29, 2017 by drdr2017

I figured out how to use a self join relationship to get a sum total of the debit part of transaction table (includes credits and debits). How do I add it to sub summary sorted by date so the sum total of debit transactions for date is displayed instead of the sum of debit transactions for all days?Untitled.jpeg

I want the total production to be per day not in total as it is shown in this summary report sorted by date.

 

Self join relationship is based on global field value of "debit" which = the field value of debit in table.

 

Total Debit = sum (self join debit::transaction amount ) --> $585

 

TO SUMMARIZE: Total production is showing overall total for all dates and I want it to show total for corresponding visit date.

Outcomes