Calculated value in reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2021 07:14 AM
Does calculated value work in reporting?
I have a calculated value which does the gliderecord query and returns a value. The script returns correct calculated value.
It appears to be showing the value in Form and lists, but when i report on the value it shows blank.
Does ServiceNow support calculated values in reporting?
Please mark my response as correct and helpful if it helped solved your question.
-Thanks
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2021 07:22 AM
I don't think so. what you can do is you can create calculate field on the table itself and include it in a database view, and then use it as reporting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2021 07:27 AM
or you can get close to this functionality by creating a field on the table, and giving it a calculation script. You can then show this calculated field in your report.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2021 07:30 AM
The field is actually on the table i'm trying to report on.
Please mark my response as correct and helpful if it helped solved your question.
-Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-14-2021 07:32 AM
you can use a database view table, which is the easiest solution to this issue
