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 val...
Forum Discussion
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
------------------------------
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
------------------------------