How to compare current row value and next row value in a column using Magellan

Sai krishna

Hi Team,

I am working on a Magellan report which contains a column with the following logic:
If( Next(col1)!=col1 ) {
Result.
}
Here it was comparing the current row value in column(col1) with next row value in that same column.

How to write this logic in Magellan using javascript.

I got strucked on this task from 1 week. Thanks in advance.

Regards,
Sai Krishna

Mikeibsons

These Employee Reports Templates are fully editable, so you may make your own special saved searches.