How To : Round time values in BMS Ad-hoc report fields.

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.

mceclip6.png

Choose Arithmetic and Geometric Functions and select Round

mceclip4.png

mceclip3.png

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

mceclip5.png

mceclip0.png

Below is an example output that shows the values rounded to 1, rounded to 0, and non-rounded values. 

mceclip10.png

Refer here for the Exago guide for these functions. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us