Skip to content

Is there a way to get the total sum, average, max, or min on a table?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #7344
    Zak Cole
    Participant

    Before you begin you will need the role, personalize list

    If you ever wonder was there a way to get the total sum value on a table without writing a background script? The hassle of finding what the table name is. Doing a query on the table. Then checking if the query was correct. Not including the time it takes to do all the google searches for sample codes. Luckily there is a build-in function in ServiceNow that will do just this. In other words, it will give you the total sum, the average, maximum value, and minimum value. The best part is you don’t need to type a single line of code.

    Procedures:
    1. Go to the table that you want.
    2. Click on the column option that contains the integers that you would like to calculate.
    3. Go to configure > list Calculations:

    4. After clicking on List Calculations a menu will pop up
    Menu
    5. Choose the option(s) that you want
    6. Scroll to the bottom where the results are
    results

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.