sicSRT8 Posted July 10, 2009 Posted July 10, 2009 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; )
mr_vodka Posted July 10, 2009 Posted July 10, 2009 I am going to assume that your: l_ff_adult - l_ff_roll1_a - l_c_ff_roll1_adj is producing a negative number.
sicSRT8 Posted July 10, 2009 Author Posted July 10, 2009 In a specific scenario yes. However I want the result just should never drop below zero but can never exceed the fields shown.
mr_vodka Posted July 10, 2009 Posted July 10, 2009 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...
comment Posted July 10, 2009 Posted July 10, 2009 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 )
Recommended Posts
This topic is 5801 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 accountSign in
Already have an account? Sign in here.
Sign In Now