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

PaulaaO
Mega Sage

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

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@PaulaaO 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@PaulaaO 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Community Alums
Not applicable

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.