Technical FAQs

Ask a Question

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

Issue:
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 thousandths place.

Resolution:
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"

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.


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 ?