Report showing the Sum of records divided by an amount
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2022 06:58 AM
Hello!
I am trying to build out some dashboards/reports to help analyze some data better. I was hoping function fields could get me what I needed but I don't believe that's where I should be looking. I am looking to build a report where the total of a column is added and then divided a specific amount.
Loose example: I want to take the total number of hours logged through Time Sheets for a week and divide it by 10.
Is this possible with just basic reporting?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2022 07:27 AM
Hi,
Not exactly what you want but using List calculation you can get the following:
- In a list of records, right-click the header of a numeric column you want to evaluate with list calculations.
- Select Configure > List Calculations.
-Anurag