{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
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.

Schneider Electric Nigeria

Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: