change the number of decimals for a number

[phh]

Hi all,
I would like to change the number of decimals so that there are no decimals.
I do not know how to do it. I have see somone use "text" but I cannot choose "text"
Maybe it's below default?

I hope you can help me!

See the Picture   

Mvh
- Peter

[timl]

Hi Peter,

If you try this, does it make a difference?

Text(ThisItem.'Ha mangler', "#.00")

[phh]

Hi @timl,

Nothing is happening 😞

See the picture 

 
- Peter

[timl]

Hi Peter,

If you try this (with a call to Value), does that make a difference?

Text(Value(ThisItem.'Ha mangler'), "#.00")

[phh]

Hi @timl,

No 😞

see the picture

- Peter

[timl · Accepted solution]

The only other thing I can think of - is 'Ha mangler' a SharePoint calculated field? There's a known problem with calculated fields not formatting correctly. If that's the case, you could also try this:

Round(
     Value(ThisItem.'Ha mangler'),
     2
)

[phh]

Hi @timl,

It is a calculated field? 

It still does not work 😞

See the picture.

- Peter 

[phh]

Hiii @timl 

sorry it work 😄

thank you!!!

-Peter

[timl]

Glad it all works now!