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.

Featured Replies

For some reason I am getting a negative number in this field when it should never be >0. Below is the exact calc I am using. I thought it would stop at 0 but getting a negative number. What am I doing wrong?

Min ( Max ( 0 ; l_ff_roll2_ft - l_ff_roll2_m_diff) ;l_ff_adult - l_ff_roll1_a - l_c_ff_roll1_adj; )

I am going to assume that your:

l_ff_adult - l_ff_roll1_a - l_c_ff_roll1_adj is producing a negative number.

  • Author

In a specific scenario yes. However I want the result just should never drop below zero but can never exceed the fields shown.

Well then shouldnt it just be?:

Max ( 0 ; l_ff_roll2_ft - l_ff_roll2_m_diff; l_ff_adult - l_ff_roll1_a - l_c_ff_roll1_adj )

Sorry I am not following your request here...

I want the result just should never drop below zero but can never exceed the fields shown.

But which expression is the result? The pattern should be:

Min ( Max ( 0 ; result ) ; upperLimit )

Create an account or sign in to comment

Important Information

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

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.