Report - Actual Cost X Estimated Cost

[Vinicius2]

Hello everyone, 

I am currently trying to create a report based on two custom fields created on the pm_project table, "Actual Cost" and "Estimated Cost", example:

The blue bar would be estimated cost and the orange bar would be the actual cost of the projects.
Is there a way to accomplish this?

[James Chun · Accepted solution]

Hi @Vinicius2,

You should be able to do this via a report and adding a dataset - https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_AddAnAddi...

e.g.

• Create a new bar graph, on the configure page, the values will be the following:
  • Group by - number
  • Aggregation - Sum, select 'Actual cost' right under the Aggregation drop-down field.
  • Save
• Select the Show report structure icon (located on the top right corner underneath the Run button)

• Select 'Add dataset'
• Select your table (pm_project), and select Bar (only option) under the Configure tab
  • Group by - number
  • Aggregation - Sum, select 'Estimated cost' right under the Aggregation drop-down field
  • (Optional) Change color under the Style tab
  • Select 'Save dataset'

Outcome below, obviously I am using the same field here.

Cheers