20
Views
4
Comments
Solved
Is it possible to represent thousands like this?: 123 456.78

Hi all,

Is it possible to represent thousands like this?: 123 456.78


Thank you

2023-12-28 15-13-10
Mauro Alviza
Solution

Yes it will. You just need to write like you want. Like I said, the third input is the decimal separator, and the fourth input is the group separator. So you would just have to put a "." in the third input, and a "," in the fourth input.

Just like this:

And the result is this:

Hope it helped.

Cheers.

2023-12-28 15-13-10
Mauro Alviza

Hi Ibtissam

Yes, it is possible. If you add an expression in your screen and use the "FormatDecimal" fucntion, you can choose the format to your number. 

I recommend you to read the documentation about the function here. But to achieve what you want, you can use it like this:

  1. The first input is the variable fo the "Number" you want, the second input is the number of decimal digits you want, the third input is the decimal separator, and the fourth is the group separator

The result is this:

Let me know if I helped.

Cheers.

UserImage.jpg
ibtissam el karchaoui

Hi, 
will it work with the same code if I have for example a number like this 70236.23 and I want to show it like this 70,236.23 

tks 

2023-12-28 15-13-10
Mauro Alviza
Solution

Yes it will. You just need to write like you want. Like I said, the third input is the decimal separator, and the fourth input is the group separator. So you would just have to put a "." in the third input, and a "," in the fourth input.

Just like this:

And the result is this:

Hope it helped.

Cheers.

UserImage.jpg
ibtissam el karchaoui
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.