How to compare current row value and next row value in a column using Magellan
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
Answers
-
These Employee Reports Templates are fully editable, so you may make your own special saved searches.
0 -
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:
JavaScriptIf (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.0
Categories
- All Categories
- 118 Developer Announcements
- 52 Articles
- 150 General Questions
- 137 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 82 Digital Asset Management
- 9.3K Documentum
- 30 eDOCS
- 175 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 6 XM Fax