StephanieLane
7 years agoQrew Cadet
formula to total then divide field
I have what seems like should be an "easy" problem to fix. I just cannot figure it out. But I know someone has ran into it before so I reach out to the oh-so intelligent community :)
I have a summary table that totals columns from two different tables. See below:
_Name_ Total Completes_ Total Hours_ Column I need help with
_So-and-So 10 80 ***(should be Ttl Hrs / Ttl Comp.)
**The Total Completes and Total Hours Columns are summing individual daily numbers in the summary report. The last column I have as a calculated column - it should divide the Total Hours by the Total Completes -- which it does fine per day. But in the summary report (or the total at the bottom of a table report) it just sums up the calculated column, rather than dividing the total hours by the total completes.
Does anyone understand?? Can anyone help???
I have a summary table that totals columns from two different tables. See below:
_Name_ Total Completes_ Total Hours_ Column I need help with
_So-and-So 10 80 ***(should be Ttl Hrs / Ttl Comp.)
**The Total Completes and Total Hours Columns are summing individual daily numbers in the summary report. The last column I have as a calculated column - it should divide the Total Hours by the Total Completes -- which it does fine per day. But in the summary report (or the total at the bottom of a table report) it just sums up the calculated column, rather than dividing the total hours by the total completes.
Does anyone understand?? Can anyone help???