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
Most Valuable Professional

@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
Most Valuable Professional

@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