Morning
I've got gallery which is returning a number from SP list. It's returning the value 6.600000000000000000. I want bring it down to just two numbers after the decimal point (6.60) and have the option to round it up just to 6.
On the Text property I've got:
"New Total: " & ThisItem.Total
I came across the following on another thread:
"[$-en-US]#.0")
but don't know where that would fit in the formula?
Thanks in advance!
I have five blocks with numbers 1-5 in each on my SharePoint list. My card shows 3.0000000000 as a total I would like a whole number.
I have copied Value(ThisItem.Value, "en-US") from this forum however, where does it go on my card? Currently I have Parent.Default.
Thanks
Tim
Just to add to this, if you choose to use the Round function, you can prefix your label with your "New Total: " label like so -
If you want to round to two decimals places, please set the Text property of the Label to following:
Share
Report
All responses (
Answers ("New Total: " &
Round(
Value(ThisItem.Total),
2
)
If you want to round up to a whole number, please modify above formula as below:
"New Total: " &
Round(
Value(ThisItem.Total),
0
)
Hi @darrenfloyd666 ,
Could you please share a bit more about the "Total" column? Is it a Calculated type field in your SP List?
If the "Total" column is a Calculated type field in your SP List, actually, it is an known issue with the "Calculated" field in SP list. The user @Casey-Lee has faced similar issue with you, please check the response within the following thread:
If you want to remain two decimals point for your Total number, please set the Text property of the Label to following:
"New Total: " & Round(
Value(ThisItem.Total),
2
)
If you want to round up your Total number value to a whole number, please modify above formula as below:
"New Total: " & Round(
Value(ThisItem.Total),
0
)
Please take a try with above solution, check if the issue is solved.
Best regards,
//This will round up to 7
Text(6.600000000000000000, "#")
//This will display 6.66
Text(6.600000000000000000, "#.00")
//This will round up to 7 in your gallery
"New Total: " & Text(ThisItem.Total, "#")
//This will display 6.66 in your gallery
"New Total: " & Text(ThisItem.Total, "#.00")
Can you clarify what you mean about rounding it up to 6?
With an input value of 6.6, did you mean that you want to round it up to 7, or do you actually want to round it 'down' to 6?
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
