Outline
When generating reports for the Service Desk module, for the categories that contain time values like Ticket Timeentries.Timespent, I want to be able to see the numbers approximated to their nearest values.
Explanation
To apply rounding to any numeric fields we can make use of inbuilt Exago functions. BMS ad-hoc reporting is based on the Exago embedded Business Intelligence (BI) solution, Read more here.
Exago formula for Round function can be used here. Add the function to the cell layout or double click or right-click on the column to insert a formula.
Choose Arithmetic and Geometric Functions and select Round
Add this formula to your field:
- =Round({Ticket Timeentries.Timespent}, 0) This will round the value to 0 decimal place, 9.19 will be rounded to 9
- =Round({Ticket Timeentries.Timespent}, 0) This will round the value to 1 decimal place, 9.19 will be rounded to 9.2
Below is an example output that shows the values rounded to 1, rounded to 0, and non-rounded values.
Refer here for the Exago guide for these functions.