Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm writing an expression where I want to use the greater of two values. I don't think the Max() expression works like I'm used to. Is there a different function to use?
An if statement like this would work, but the problem is that "value" is 6 lines of code that I'd end up having to repeat two times.
If( value > 0, value, 0)
I'd much rather have a function like this
max(value, 0) so that I only write "value" once.
Any ideas? Thanks!
Use RangeMax() function. Like:
RangeMax(Value,0)
RANGEMAX(value1,value2)