How to set values in a list that are greater than 1 to 1

Hi there, I have a resultant list of 134 records that are between 0 and 1.8, is it possible to take this list and turn all the values that are greater than 1 to be equal to 1.

Sorry if this is an easy fix, new to the software and have searched for answers but am drawing blanks. Thanks for your time :slight_smile: `

An if statement in design script should do the trick:

a < 1 ? a : 1 ;

The format for these is:
test ? resultIfTrue : resultIfFalse ;


Thank you. :smile:

1 Like