format dci coordinate

[Egert143]

Hello

When i have coordinate dci for example "5837845.0", how can i convert it to "58.37845"?

I tried Transformation with "return $1/100000;" but this results "58.378520", there is extra 0 in the end. How to remove it ?

Egert

[Filipp Sudanov]

return format($1/100000, 1, 5);

should do the job. https://www.netxms.org/documentation/nxsl-latest/#func-format

[Egert143]

When i tested format, under history it shows correctly, no trailing "0". But under Last Values, it still shows extra "0".

Also when i test without format, it still show correctly in history, but with extra 0 in Last Values.

[Filipp Sudanov]

This depends on whether your DCI is string or float. Looks like it's float - in this case displaying works with 6 digits after comma. If you select string it will probably show as you like.

[Egert143]

With string formating it shows correctly, but then its not possible to create thresholds with less than or greater than.

[Filipp Sudanov]

Actually this is a bug - in last values it should be displayed the same way as in history. This will be fixed.

In the future custom formatting will be implemented - you can follow this issue: https://track.radensolutions.com/issue/NX-2265

[Egert143]

Many thanks

Egert