Page 1 of 1

Functions

Posted: Sat Dec 11, 2021 3:11 pm
by panos3
Hello,

In my model I have a variable depending on a lookup coefficient. As the time passes the coefficient either reduces or increases so does the variable. How can I set the variable to stay constant if the new value for the coefficient is lower than the previous one?

Re: Functions

Posted: Sat Dec 11, 2021 8:55 pm
by Administrator
I don't understand what you are explaining. But I'll have a guess.

You can use the SAMPLE IF TRUE function to keep the value. For example

my value = sample if true ( coefficient > my value , coefficient, coefficient )

This will only increase "my value" if coefficient is greater than the last value for "my value".