- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2024 04:03 AM
Hi Community,
If there is vlookup applied in excel, then how to create reports for this? Is there any functionality related to vlookups in servicenow?
Thanks,
Poorva Bhawsar
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2024 01:05 AM
Now you bring the real use case 😀
So now it come to SN, and lets see in which tables these 2 records get stored are in same table or 2 different table?
It is like like I want SLA and Incident records where inc record exits in SLA table.
1st Get the both field table
Then see is it same or 2 different table
3rd , how these 2 tables related like as related list or what
Create DB view or use standard reporting ( if Related list is the case ) and get the result.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2024 01:18 AM
It was just an example, there are so many tables and columns into this report and all are formula based.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2024 01:38 AM
One more point, please check, is it worth building this report in SN? Like how many times this report will be used in a year / how much time it will save. As you say it is formula formula-based so might be there are few things which can't be done in SN. So check end-to-end feasibility before you start building.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2024 04:41 AM
it would be a scheduled report. Schedule is not decided yet. Formulas are just for the percentage calculation like blah blah field non empty values/total % like this.
Now i have one more question here,
if using vlookup we are getting value of a field, then how to create that field into a servicenow custom table?
Example is given above with screenshot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2024 04:43 AM
From the report, you can just get the match, but to store that you need to create a field in required table and store. FYI- Creating new field is customization & can be chargeable too.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2024 01:21 PM
Hi @Poorva Bhawsar ,
no, there is no such thing as vlookup in ServiceNow.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
