cancel
Showing results for
Did you mean:
Post Prodigy

## How to round a decimal number to two places

Hi All,

The following formula gives me a decimal number from a calculated list column, in the column it is 2 decimal places. But in Power automate it is 5/6 who can I round it down to two?

``````With({wactivity:
SortByColumns(
Filter(
'Activity Tracker',
StartsWith('Created By'.Email, glbUser.Email)  ),
"ID",
If(SortDescending1, Descending, Ascending)
)},
Sum(Filter(wactivity,'Date of Activity' >= Date(Year(Today()), Month(Today()), 1) && 'Date of Activity' <= Date(Year(Today()), Month(Today()) + 1, 0)),'Total Hours')
)``````

Thanks to @Drrickryp for the initial formula.

John.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

@jbrines  To round off decimal value in Power Automate to two decimal places you can refer to this post https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Round-off-to-two-decimal-places-using-Po...

Regards,
Anna Jhaveri

If you like my response, please give it a Thumbs Up.
2 REPLIES 2
Super User

@jbrines  To round off decimal value in Power Automate to two decimal places you can refer to this post https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Round-off-to-two-decimal-places-using-Po...

Regards,
Anna Jhaveri

If you like my response, please give it a Thumbs Up.
Post Prodigy

Sorry silly me I meant to put it in Power Apps, going to to do tha now

Announcements

#### Back to Basics: Tuesday Tip #2: All About Community Ranks

This weekly series is our way of helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we will feature new areas of content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!   Have you ever wondered how your fellow community members earn the different ranks available? What is the difference between an Advocate and a Helper, a Solution Sage and a Community Champion? In today's #TuesdayTip, we share the secrets and tips to help YOU keep your ranking growing--and why it's so important to our communities. What are community ranks? - Power Platform Community (microsoft.com)   Get the details in this Knowledge Base article that shows you what ranks are, how they are achieved, and what they mean to you as you engage with other community members on a regular basis. Once you start your journey in the community, ranking up, you'll find the benefits. So get busy with those kudos, solutions, and more! We can't wait to see how you rank!That's it for this week. Tune in for more Tuesday Tips next Tuesday and join the community as we continue to get "Back to Basics."

#### It's #MPPC23 Week! Check Out the Community Sessions and Events Happening in Vegas

After all the planning and preparing, the annual Microsoft Power Platform Conference is finally here! We are excited to see so many of our community in Las Vegas this week. To help make sure you don't miss any of the workshops, sessions, and events we have planned, make sure to check out this handy Community One-Sheet, and download the pdf today! Make sure to stop by the Community Lounge to meet @hugobernier, @EricArcher, @heaher_italent, and @AshleyFelts from our team!