Calculate Difference Between 2 Summed Fields on Report Dashboard

[kshaw]

I am creating a simple balance dashboard for donated hours.

2 lists show donations vs withdrawals. At the top are 2 single count scores that are the sum of the donation field and withdrawal field. 

What I want to then show (blue count widgt) is the balance. How do I calculate the diffence between the sum of the donations and the sum of the withdrawals?

 

[Maik Skoddow · Accepted solution]

This is not possible in ServiceNow as you cannot take the results of several reports as inputs for another report.

Instead, I recommend adding a function field to the report which creates the difference for each row and then sum up over that function field.

See https://docs.servicenow.com/bundle/washingtondc-now-intelligence/page/use/reporting/concept/function...