RyanBunting
5 years agoQrew Member
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
------------------------------
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
------------------------------