To compare cell values with the previous one, you can use the OVER function:
for strings:first([str]) over (previous([rid])) = First([str]) over ([rid])
for numbers:(first([num]) over (previous([rid])) - First([num]) over ([rid]))=0
Note: [rid] is a calculated column using rowId() function.
Unfortunateley we cannot use rowId() within the over expression, so we need to create the rid calculated column.
for strings:first([str]) over (previous([rid])) = First([str]) over ([rid])
for numbers:(first([num]) over (previous([rid])) - First([num]) over ([rid]))=0
Note: [rid] is a calculated column using rowId() function.
Unfortunateley we cannot use rowId() within the over expression, so we need to create the rid calculated column.
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon