Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calculation question for two fields

mcyrulik
in Calculation Engine (Define Fields)

Featured Replies

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

See if this helps:

http://www.fmforums.com/forum/showpost.php?post/165927/

  • Author

That worked perfetly!

Thanks a Million comment!

  • Author

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?

Create an account or sign in to comment

https://fmforums.com/topic/53883-calculation-question-for-two-fields/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.