Report showing the Sum of records divided by an amount

jtweito
Kilo Contributor

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

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

Not exactly what you want but using List calculation you can get the following:

 

  1. In a list of records, right-click the header of a numeric column you want to evaluate with list calculations.
  2. Select Configure > List Calculations.
    The list calculation window appears.
    List v2 list calculation window
    List v2 list calculation options
-Anurag