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.

danielalbright

Certainly, Sai Krishna! To achieve the logic of comparing the current row value in column col1 with the next row value in the same column using Magellan, you can use the following approach:

Create a calculated column that calculates the value for the next row in col1. Let’s call this column Next_col1.
In your report, use the following expression to determine if the current row value in col1 is different from the next row value:
JavaScript

If (col1 != Next_col1) {
// Your desired result or action here
}
AI-generated code. Review and use carefully. More info on FAQ.
Remember to replace // Your desired result or action here with the specific logic or action you want to perform when the condition is met.