Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm have difficulty creating an expression that will evaluate another expression and assign a point value based on a range of values.
Here is what Im trying to do
IF [ExpressionName] is between Value1 & Value2 return '1'
IF [ExpressionName] is between Value3 & Value4 return '2'
IF [ExpressionName] is between Value5 & Value6 return '3'
IF [ExpressionName] is greater than Value7 return '4'
This should be all contained in one expression and the values will need to be hard coded Can someone please provide some guidance/help?
Thanks.
Brian
Something like:
if([ExpressionName]<Value1, 0,
if([ExpressionName]>=Value1 and [ExpressionName] <Value2, 1,
if([ExpressionName]>=Value2 and [ExpressionName] < Value3, 2,
if([ExpressionName]>=Value3 and [ExpressionName] <Value4, 3,
if([ExpressionName]>=Value4, 4
)))))
Hope this helps!
Thanks, works perfectly.
Hi,
another solution could be:
Match(-1,
vExpressionName >= 1 and vExpressionName <= 2,
vExpressionName >= 3 and vExpressionName <= 4,
vExpressionName >= 5 and vExpressionName <= 6,
vExpressionName >= 7)
hope this helps
regards
Marco