Problems with calculated field
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2018 10:57 AM
Good day,
I have a problem with a calculated field, in this field a String should appear depending
on the calculation of the difference of dates, the calculation and the assignment
is given correctly, but when I make reports with this field they appear empty.
I attach screenshots.
1. This is my definition of the calculated field.
2. This is my code to calculate and assign a string to that field.
3. Here we see that if you calculate it and assign the string correctly.

4. We can even export it in excel and if it shows the value.

5. But when a report is made the moyoria goes empty.

Please I need help.
Thank you very much
Regards,
Labels:
- Labels:
-
Incident Management
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-13-2018 12:48 AM
Hi, Jose Incio ServiceNow
Looks like the issue is that you trying to calculate string value. The issue is when you're creating report, Aggregation-> Count works not with all data types. In your case it is String. To get the result you need to convert string to Number or other format that could be calculated. That's why you can't see anything in your report.
Please refer to ServiceNow documentation here:
https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/administer/report_administration/reference/r_AdministerReports.html