Syntax of FORMAT and ROUND

[[Er...]]

Hello,

Does anyone know where I can find the full syntax of the table expression keywords format and round?

Regarding format, the Tech Guide states that the "field width" can be adjusted, but it doesn't explain how.

The explanation regarding round is not clear. How can I round to 2 decimal places?

 

Best regards,

Erik

Edited February 10, 2025

[[Na...]]

Hi Erik,

For the format expression, I recommend to use the Fx button in the expression editor and enter the values in the dialog. You can late edit them in the code:

... this will result in this code for example:

format (VALUE, "+98.0", show_unit=false)

For the rounding you could use Decimal places from the format() output.

[[Qu...]]

Hi Erik, 

This works for display purposes on individual values. I wondered if there was a way to round the value itself to enable further calculation with rounded values rather than a string operation. As you can see below attempts at addition simply add the string together.