You’re offline. This is a read only version of the page.
7
Hi @v-litu-msft
My apologies for the typo. You made my day, have been trying multiple ways to convert that string to text. All efforts failed, was struggling last day.
your solution worked flawless, Many thanks.
Cheers,
Balaji
Hi @balajimr2,
Could you please share the calculated column value how show in the output?
Why it will show 0.079767657? Not 0.79767657?
If it is miswritten, you could following the screenshot to approach that:
use float() function convert it to float, then use Format number action convert it to percent format, the Format could set to "P01", it means has one decimal. If you want it to have no decimal, you could set it to "P00":
Here are documents about number format in Microsoft for reference:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings#example
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
