Jump to content

Calculation question for two fields


This topic is 6154 days old. Please don't post here. Open a new topic instead.

Recommended Posts

OK ladies and gentlemen,

The attached picture is out of an estimating program I built. As it stands, the markup field is edited by the user, which then calculates the unit price and the total price. Works great....

Now my user wants to have the flexibility to update either the markup or the unit price and have the other update accordingly.

If I put auto enter calcs on both fields, and I update the markup, the unit price updates, but then because the unit price updated, the markup updates again.

Is there a way that I can stop the field that was just edited from updating, but still have the other one update correctly?

Picture_1.png

Link to comment
Share on other sites

I got the desired result - sort of.

the one problem I ran into is that using this method, the unit price does not update when the unit cost changes - just when the markup changes.

The unit cost field is a calculation of total_cost/qty.

I have tried using total_cost/qty in place of unit price in the else protion of the if, but that doesn't seem to work.

Any ideas on ways around this?

Link to comment
Share on other sites

This topic is 6154 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.