Problems with calculated field

Jose Incio Serv
Tera Contributor

‎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.
find_real_file.png
2. This is my code to calculate and assign a string to that field.
find_real_file.png

3. Here we see that if you calculate it and assign the string correctly.
find_real_file.png

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

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

find_real_file.png


Please I need help. 
Thank you very much
Regards,
Labels:
Preview file
38 KB
Preview file
80 KB
Preview file
45 KB
Preview file
67 KB
Preview file
47 KB
0 Helpfuls
  • 1,672 Views
1 REPLY 1

ScienceSoft
Tera Guru

‎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

0 Helpfuls