How to round up value when displaying data log in ION Enterprise, SPM, and PME Vista

Issue:
The customer does not want accuracy higher than whole number values.

Product Line:
ION Enterprise
StruxureWare Power Monitoring (SPM)
Power Monitoring Expert (PME)

Environment:
Vista Data Log Viewer
Web Applications Data Log Viewer

Cause:
Software rounds to the thousandth place.

Resolution:
Confirm that Show Toolbox is checked in Options in the top-left then right-click on the data log viewer that needs to be changed in Vista. Go to the Query tab and click Edit SQL ... Add a ROUND function to the queries, for example

SELECT timestamp
, "Vll ab mean"
, "Vll bc mean"
, "Vll ca mean"

becomes

SELECT timestamp
, ROUND("Vll ab mean", 0) AS "Vll ab mean"
, ROUND("Vll bc mean", 0) AS "Vll bc mean"
, ROUND("Vll ca mean", 0) AS "Vll ca mean"

Save the file. Double-click on the data log viewer and you should see the value is rounded up to the nearest integer.