Report Formula: Sum total

Question

Hi,&nbsp;I have two columns Erect Hours and Total Pieces Erect.&nbsp;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.91I tried using this Sum([Build - Erect Hours])*60/Sum([Build - Total Pieces Erect]).&nbsp;However, it is not calculating the column total but it is calculating row total. &nbsp;Any help will be appreciated.------------------------------Bibhav Rimal------------------------------

prashantmaheshw · Answer

I believe Summary Report would be a better bet to achieve what you want.------------------------------Prashant Maheshwari------------------------------

bibhavrimal · Answer

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
------------------------------

bibhavrimal · Answer

Any help on this would be appreciated.------------------------------Bibhav Rimal------------------------------

dwightmunson1 · Answer

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
------------------------------

bibhavrimal · Answer

Thank you both. Summary report solved the problem.------------------------------Bibhav Rimal------------------------------

Forum Discussion

Report Formula: Sum total