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
Solved! Go to 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
)
Hi Peter,
If you try this, does it make a difference?
Text(ThisItem.'Ha mangler', "#.00")
Hi Peter,
If you try this (with a call to Value), does that make a difference?
Text(Value(ThisItem.'Ha mangler'), "#.00")
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
)
Hi @timl,
It is a calculated field?
It still does not work 😞
See the picture.
- Peter
Glad it all works now!
User | Count |
---|---|
256 | |
106 | |
86 | |
51 | |
43 |