Skip to main content
Question

Report Formula: Sum total

  • February 1, 2023
  • 0 replies
  • 377 views
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
------------------------------
This topic has been closed for replies.

  • BibhavRimal
  • Author
  • Registered
  • February 1, 2023
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
  • Author
  • Registered
  • February 2, 2023
Any help on this would be appreciated.

------------------------------
Bibhav Rimal
------------------------------
Terms & ConditionsAccessibility statement