Technical FAQs

Ask a Question

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

Customer does not want accuracy higher than whole number values. 

Product Line:

ION Enterprise
StruxureWare Power Monitoring (SPM)
Power Monitoring Expert (PME)

Vista Data Log Viewer
Web Applications Data Log Viewer

Software rounds to the thousandths place.

Confirm that Show Toolbox is checked in Options 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"


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.

Legacy KB System (APS) Data: RESL200776 V1.0, Originally authored by KBAdPM on 12/23/2009, Last Edited by KBAdPM on 12/23/2009
Related ranges: ION Enterprise V6.0, ION Enterprise V5.6
Was this helpful?
What can we do to improve the information ?