can I add a calculated column to a summary table that does not summarize or total?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a column of revenue totals and a corresponding column of time adjacent to those revenue totals and I would like to divide the two columns by each other to get a $/hour number.  The calculated column that I add to the summary report is correct, but when it gets added to the summary report it gets summarized and totalled.  I only want the division to happen straight across each row to show the $/hour, not summarized or totalled in any way.  Possible? 

Photo of Joseph

Joseph

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Chandrajeet

Chandrajeet

  • 0 Points
Seems like you need a "formula field" may be of type text or numeric. And in that formula you specify you want to divide this column by that column. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
I think that you will find that you cannot suppress the grand totals below or to the right.