NetXMS Support Forum

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

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

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

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.

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.

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

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

Many thanks

Egert