# Discussions

View Only
• #### 1.  Report Formula: Sum total

Posted 02-01-2023 13:05
Hi,

I have two columns Erect Hours and Total Pieces Erect.

This is what I want to get at using report formula;

(Sum of Total Erect Hours * 60) / Sum of Total Pieces Erect. (64102.36*60)/352507.5 = 10.91

I tried using this Sum([Build - Erect Hours])*60/Sum([Build - Total Pieces Erect]). However, it is not calculating the column total but it is calculating row total.  Any help will be appreciated.

------------------------------
Bibhav Rimal
------------------------------

• #### 2.  RE: Report Formula: Sum total

Posted 02-01-2023 13:39
I tried using this formula in excel by downloading the report and it works. The Max function in Quickbase doesn't work for me.

=MAX(SUM(F2:F2205)*60)/(SUM(E2:E2205))

------------------------------
Bibhav Rimal
------------------------------

• #### 3.  RE: Report Formula: Sum total

Posted 02-02-2023 17:52
Any help on this would be appreciated.

------------------------------
Bibhav Rimal
------------------------------

• #### 4.  RE: Report Formula: Sum total

Posted 02-05-2023 06:50
I believe Summary Report would be a better bet to achieve what you want.

------------------------------
Prashant Maheshwari
------------------------------

• #### 5.  RE: Report Formula: Sum total

Posted 02-06-2023 10:19
Each row is it's own record. So if you have a formula it's only going to affect/pull data from that record. So there's two ways to slice this:

1) Create a summary report for this data
2) Create a fomula query, query all the relevant records for the data, and display a running total.

**3rd way, I don't know your app structure, but if these are child records to a parent, or could be, you could summarize that data at the parent level and do the calculation there.

------------------------------
Dwight Munson
------------------------------

• #### 6.  RE: Report Formula: Sum total

Posted 02-06-2023 16:30
Thank you both. Summary report solved the problem.

------------------------------
Bibhav Rimal
------------------------------