cancel
Showing results for
Did you mean:
Frequent Visitor

## Forcing a number to have 2 decimal places. Example 5.123 to 5.12 and 6.2 to 6.20

I'm multipling alot of numbers where the answer may go out past 2 decimal places and sometimes the answer is 1 decimal place. What ever the answer is I need it to be 2 decimal places. Example...5.2 needs to be 5.20 and 5.123 needs to be 5.12. I dont care about rounding up or down. In the example below, what steps do I need to do to limit the answer to just 2 decimal places? Thanks in advance 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

You can do this by wrapping your formula inside a call to Text like so:

``````Text(<insert your formula here>,
"#.00"
)``````
2 REPLIES 2
Super User

You can do this by wrapping your formula inside a call to Text like so:

``````Text(<insert your formula here>,
"#.00"
)``````
Frequent Visitor

I did have to add another "value" in the beginning of the formula but it worked. Thanks for the help.

Working formula...

Text((Value(Value(DataCardValue7.Text)*425.36+Value(DataCardValue8.Text)*309.36+Value(DataCardValue9.Text)*260.4+Value(DataCardValue10.Text)*312.15+Value(DataCardValue11.Text)*464.65+Value(DataCardValue12.Text)*470.53+Value(DataCardValue13.Text)*110.81+Value(DataCardValue14.Text)*92.1+Value(DataCardValue15.Text)*139.16+Value(DataCardValue16.Text)*325.32+Value(DataCardValue17.Text)*386.15+Value(DataCardValue18.Text)*216.29+Value(DataCardValue19.Text)*365.54+Value(DataCardValue20.Text)*105.72+Value(DataCardValue21.Text)*43.61+Value(DataCardValue22.Text)*48.55+Value(DataCardValue23.Text)*43.18+Value(DataCardValue24.Text)*45.21+Value(DataCardValue25.Text)*50.4+Value(DataCardValue26.Text)*45.74+Value(DataCardValue27.Text)*46.39+Value(DataCardValue28.Text)*49.66+Value(DataCardValue29.Text)*46.63+Value(DataCardValue30.Text)*46.7)*1.6),"#.00")

Announcements

#### Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.

#### Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Top Solution Authors
Top Kudoed Authors
Users online (4,451)