Report Formula: Sum total

Question

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

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

Sign up

Login to the community