Forum Discussion

RyanBunting's avatar
RyanBunting
Qrew Member
5 years ago

Calculated Field in Report

I have a report that asks the user for 2 dates, and then filters down a table on a per-person basis with their relevant data in the given range.

I need to just perform a simple calculation on 2 values in the row - [Containers Moved] divided [Hours Worked], based on only the FILTERED data, and display that number in its own column at the end of the row.

For example, if between 1/1/2020 and 1/1/2021, John Doe had 200 hours worked, and 6000 container moves, I need the number "30" to be at the end of John Doe's row.

When I create a Report Formula, I can't simply just display the result of that formula, since it's a summary report, I have to choose to Total it, Average it, or what have you. I've tried some jank to make it work with a Table Report, but run into the same error.

Is there something simple I'm missing here? Or is it impossible to have a report with an extra field that does a simple calculation based on 2 values in a row?

------------------------------
Ryan Bunting
------------------------------
  • You should be able to do it on a table report, like this? Create a formula numeric field



    ------------------------------
    Everett Patterson
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      It is not currently possible to do arithmetic calculations on columns in a summary report. But supposedly it is on the roadmap for near term development.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
  • Hi Ryan,

    Mark is correct that we are working right now on our formula engine to enable the exact type of use case you are looking for. Harrison from our product team just recently published an article talking through our upcoming formula enhancements right here. It is currently possible to do what you are looking for using what we call a statistics table where you use relationships to help you bucket and summarize information like it is broken up in your report to allow you to do calculations on these aggregate records, obviously that just takes more work. There is an example of doing that with a months table in this article here.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------