Skip to main content
Question

Can you create a calculated column in a Summary Report that uses other columns in the report to generate the final column?

I have two columns in a summary report that I would like to generate the third column. The first column is Total Moves, the second column is Total Hours, and I would like the third column to be the first column divded by the second column. I am able to get close by using an average on that calculated field, but what I would really like is for this column to be exactly correct. Any suggestions would be greatly appreciated.
    This topic has been closed for replies.

    At this time you cannot do calculations between columns on a Summary report.  The only way to do this would be to create a new table where the Key field was, for example,  the first day of each month going forwards or backwards for a bunch of months.  Then make a relationship back to that table with a formula field like

    FirstDayOfTheMonth([Move Date])

     and Summarize the Total Hours and Total Moves.  Then  do your calculation on that monthly table.

    If you need finer slicing and dicing I have some ideas on that too.
    And Excel wins again... :'(
    • AustinK
    • Registered
    • April 12, 2019
    Does just making one of the columns on the report a formula field and doing the calculations in there not work for this? I thought using a calculated column to add up other columns on the reports worked too, I am almost positive I have summary reports like that.

    It's possible I am missing something obvious here though. It sounds like you want something pretty simple, a column that will divide column 1 by column 2 and have the result in the 3rd column. Is that right?
    Terms & ConditionsAccessibility statement