Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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