Problems with calculated field

Jose Incio Serv
Tera Contributor
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,
1 REPLY 1

ScienceSoft
Tera Guru

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