Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.Register Now
Does ROUND only work to the whole number, or is there a way to specify the number of digits that the calculation could be rounded to. I didn't see any see any documentation on this, but am trying to work on something during UAT to test a solution for Adrià Casas and the Auchan project team.
Solved! Go to Solution.
ROUND only does whole numbers, but the old school trick to get a particular precision is to scale, then round, then scale back. So if you want two digits of precision after the decimal, you'd do ROUND(<expression>*100.0) /100.0
This will trim the precision of the number, but doesn't necessarily affect the display of that number - that's up to the chart. So it doesn't affect whether data is displayed with following zeroes, but it does trim off unwanted precision.