Total Value not available in List Calculations

Daniel O_Connor · ‎08-06-2019

Hi all,

I have a variable field that I've been asked to report on. The record contains a field that outlines the no of line items on an attached form. So I've been asked to show the monthly sum of line items actioned by members of X team.

I've also been asked to show the total line items actioned by the team as a whole.

Weirdly difficult to achieve in ServiceNow. This article outlines how to set a "field" as being able to totalise

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/list-administratio...

When I review on my end, I only get the below

What I really want are two reports

1) Bar chart report showing SUM of No of line items per user last month

2) Total figure of No of Line items for the team last month

However when I go to the charts and select SUM it gives me loads of what look like SLA options, nothing to do with the fields on the table?

I basically want to SUM No of line items here so the report will show a bar chart of Closed By but the bars represent the no of line items, summed

Also just trying to the simple full number count, again all these what look like SLA based options appear talking about resolutions times and stuff

Appreciate any help here, this is a simple requirement but I'm really struggling to work out how ServiceNow lets me do it

Andrew_TND · ‎08-07-2019

Hiya

I've had this issue in the past you may need to change the field to a number related field type such as Decimal or Floating number point because if its a string or anything else snow doesn't recognise it as a number.

Warning if you do change it to a decimal you will only be able to report on the figures update from that day. So if you change the field from 07/08/2019 you wont be able to report on anything updated prior to that date.

Let me know how you get on.

Cheers

Andrew

View solution in original post

Andrew_TND · ‎08-07-2019

Yeah at a previous company I had this issue because when it was implemented by the consultancy they had a habit of creating every field as a string field regardless which made reporting a nightmare!!

Mark this as helpful if its helped. 🙂

Daniel O_Connor · ‎08-07-2019

Thanks Andrew.

Was in fact a string field. Created a new integer field and then just copied over the content from the old one into the new one. And presto, I'm up and running.

Noticed you mentioned about it only working from today on. You can use background scripts to in this instance, copy existing data from one field into another. Can throw you my script if you want? Have used it a bit for stuff like this and it works a treat