Total Value not available in List Calculations

[Daniel O_Connor]

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 

[Adam Stout]

From the list view, try clicking on the field "Number of Line Items" field and creating a bar chart.  Perhaps that will help you get started.

[Daniel O_Connor]

Hi Adam,

Yeah I have been able to get that sort of layout through report builder. It groups by no of line items which I guess bar charts the different "no of line items" as opposed to where I need to bar present the user, and the sum of the line items they have actioned

[Andrew_TND · Accepted solution]

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

[Daniel O_Connor]

This is a really good shout actually. The module in question was built before I manged ServiceNow so while I'd make something like this a numerical data type no idea if the previous crowd did.

Will check this now.