Comparing two fields in one table with the report

[ParkHyunSun]

Hi I have a problem with creating a report.

I would like to create a report which can show the sum of two fields.

Below are requirements to my report.

1. The report is grouped by assignment group.

2. There is one field to sum the working time. I used the aggregation.

3. This is the problem. There is another custom field that end user inputs their working time manually, and they want to compare #2 and #3. In this situation, how can I set this custom field in report? For the convenience, I will call this field 'Input Field'.

At first I thought it would be solved with OOTB function, but couldn't figure out how to do it. Please help me out.

Thank you.

[AndersBGS]

Hi @ParkHyunSun ,

What should be the outcome of the comparison? In general, my initial though would be to "configure a function field":

Here you do different types of calculations with could give you the output that you're looking for:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[ParkHyunSun]

Hi Anders, thank you for answering my question, but that's not my requirement.

Below is what I want to make with report.

I don't want to make subtract, or calculate. I just want to see them separately.

Thank you.

[AndersBGS · Accepted solution]

Hi @ParkHyunSun ,

Ok, got it. Then I would recommend you to add a dataset to the report instead meaning, first dataset you can report on the duration time, second dataset you can report on the input field (according to your picture above). You can see how to add a data set in a report here:https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/task/t_AddAnAdditio...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[ParkHyunSun]

It works for me!!!!

Thanks!!!