cancel
Showing results for
Did you mean:
Helper I

## Calculate \$ and % fields dynamically based on change of each other

I've managed to solve my issue on one side, but not dynamically based on two fields referencing each other.

What I have:

• Order \$ field
• Estimated \$ field
• Estimated % field

All live in a form, all are editable.

What I need:

The estimated field should be: Estimated field = Order \$ * Estimated %

BUT, the estimated field can also manually be set, in which case I need the Estimated % to change.

Estimated % = estimated \$/order \$*100.

So based on which estimated field is changed the other needs to dynamically change accordingly. In my attempts, I get a circular reference error.

Any help is greatly appreciated.

5 REPLIES 5
Super User

To make sure I understand.  This is the formula for the Estimated \$ field?

The estimated field should be: Estimated field = Order \$ * Estimated %

What should the formula be for the Estimated Percent field?

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
Helper I

Correct.

Estimated percent is the estimated \$ divided by the order \$ * 100

Super User

I think something is missing here.   If both Estimated \$ and Estimated % start out blank and are relying on each other, you won't get any sort of result.

For example, if there were no error, both Estimated \$ and Estimated % start out as Zero.   If my order \$ is 150 and I multiply that by 0% (Estimated \$), I get a zero value.

So is there a default percentage or number that you would be using?  Otherwise I am not sure how your calculations are going to work

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
Helper I

On initial creation in the form, the user would be setting order \$ and estimates (either \$ or %).

Could start with a common % if that's needed to make it work. Something like 5%.

Super User

Try this.  For your Estimate \$

1. OnChange Property:  Set(varEstimateDollar, Value(Self.Text))
2. Default Property:  Value(Order.Text) * varPercent

Leave the Estimate% formulas the same.

This should solve your circular error situation.    It will update the variable if the field is manually changed again and everything should calculate dynamically

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

Announcements

#### Microsoft Power Up program unveils new curriculum and more

New engaging and cohesive Power Up curriculum The Microsoft Power Up Program – a self-paced upskilling program, launched in 2022 to help non-technical professionals gain marketable skills using the Microsoft Power Platform – takes learning to the next level with a cohesive video-based curriculum that spans only seven weeks. Recognizing the demand for multimedia content, we partnered with Microsoft MVPs Rory Neary and Charlie Phipps to create engaging videos that not only simplify complex concepts, but also make the learner experience more dynamic and immersive. Each course follows the same business through real-world scenarios with demos and hands-on exercises for learners to gain skills and build solutions using Power Apps, Power Automate and Power BI. This structured approach not only enhances comprehension but also equips learners with tangible skills that can be applied immediately in their professional endeavors. By focusing on key areas, the program has been shortened from 12 weeks to seven, saving valuable time without sacrificing quality. Special thanks go to Microsoft Power Platform advocates, April Dunnam and Renee Noble who shared their expertise and to Power Up Program champs who contributed with feedback and reviews over the last 1+ year to make this significant improvement.   Easy access to a comprehensive Development Environment In addition, the program now offers simplified and instant access to a comprehensive development environment for Power Up Program learners to explore and experiment with the Power Platform in a sandbox environment, fostering creativity and innovation.     Introducing App-In-A-Day (AIAD) workshops for Power Up learners As an added incentive, participants of the Microsoft Power Up Program can now sign up for partner-led “App in a Day” virtual workshops. These workshops, conducted by industry experts and Microsoft partners, provide invaluable insights and practical guidance to supplement the core curriculum. By attending these workshops, learners can gain deeper insights into application development and further enhance their skills in leveraging the Power Platform for business solutions. A big shout to our partners that are supporting the Power Up Program and delivering these AIAD workshops: Advaiya, Almato AG, Braintree, Kaispe, Koenig Solutions, PowerApps 911, Pragmatic Works, Smart Consulting.   These enhancements introduced to the Microsoft Power Up Program mark a significant milestone in the ongoing quest to empower individuals with the skills needed to thrive in today’s digital economy. By embracing video-based learning, streamlining the curriculum, and offering personalized experiences, the program continues to set new standards of excellence in virtual education. Sign up today to start your Power Up learning journey (https://aka.ms/PowerUp/)   by Dimpi Gandhi, Principal PM Lead, Power Up ProgramRepost from Microsoft Power Platform Product Blog

#### Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Our team will be reviewing posts using the new "Copilot" label to ensure we highlight and amplify the most relevant and recent content, so you're assured of high-quality content every time you visit. If you share a post that gets featured in the curated gallery, you'll get a PM in the Community to let you know!The curated gallery is ready for you to experience now, so visit the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community. We can't wait to see what you "cook" up!