{}

Our Brands

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

Welcome to the Schneider Electric Website

Welcome to our website.
How can we help you today?
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 UK

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: