Report - How to show sum quantity for variable within RITM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2023 06:12 PM
Hi folks,
Been working on a report and requesting your reporting wisdom 🙂
I am trying to have a Column Time Series show the count of assets entered into the RITM (Transfer of Disposable Assets).
Best I can manage is a count with just the request, but not the count of assets entered. Is this even possible? It is a field where no numerical quantity is entered / selected but asset tags entered in (much like OOB shared mailbox multiple users can be added field). I know everything is a record in a table, just don't know what this table is called.
I have set it up from Data Table - Requested Item
Type - Time Series Column
Configure - Group by Variables - Transfer of Disposable Assets - Select Assets from List
Is there a way for me to get it to show the count of those asset total, rather than the request?
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2023 11:24 PM
did you try using function field in reporting?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader