Configure function field in a report (percentage/decimal and currency)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2025 08:38 AM
Hi,
I have a report requirement where I need to display the calculation between a percent_complete type field and a currency type one and I was wondering if I could achieve this via a function field created directly within the report.
I had a go using the multiply () function but without success and I believe it's due to both fields being of different types. The percent_complete field is custom and I can update its type to decimal if that would make any difference.
Is there any way this can be done using function field from Reporting or should I try other avenues, e.g. calculated field?
Thank you in advance 🙂
Paula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2025 08:40 AM
Hi @PaulaaO I doubt this can be achieved with different data types, as functions mainly work with the same data type.
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
07-09-2025 09:00 AM
Function field multiple will work when you have 2 values which are numeric either integer/float/decimal.
Try getting the currency value using substring function and then multiple both the fields. Make percent complete as decimal
If the above doesn't work then
please use a custom field and make it calculated and add script in that
then use that field in your reporting
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2025 11:41 PM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2025 12:22 AM
You’re right — mixing a percent_complete field (which is a percentage) and a currency field directly in a function field in standard ServiceNow Reporting often won’t behave as expected, because function fields are quite basic and don’t always handle type conversion or math across different data types smoothly.
Here’s what you can do instead:
✅ Use a Calculated Field:
Go to the table that stores your data.
Create a new field (e.g., u_calculated_amount) with type Decimal or Currency (depending on what makes sense).
Set it as a Calculated field in the dictionary, and use the calculation:
percent_complete / 100 * currency_field
If your percent_complete is stored as 0–100, divide by 100.
If it’s already stored as a decimal (0–1), then multiply directly.
This way, the value is always ready to use in reports without worrying about runtime conversions.
✅ Then in the report:
Simply add this calculated field as a column, or aggregate it if needed.