This is a migrated thread and some comments may be shown as answers.

Conditional formatting based on previous row

3 Answers 108 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Roland
Top achievements
Rank 1
Roland asked on 24 Mar 2014, 08:08 AM
I have a requirement for a report, that when a certain field's value is different from the previous one, I need to add a top border to the cell.
Conditional formatting with the following expression, but it does not produce the desired result. The Last() appearantly does not work in a way I imagined..

= Last(Fields.Name) <> Fields.Name = true

Could I ask for some advice please?
Jenner
Top achievements
Rank 1
commented on 11 May 2021, 11:03 PM

= Fields.Name = = Previous( Fields.Name )

3 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 26 Mar 2014, 01:29 PM
Hello,

The Last(Expression) aggregate returns the last value from the specified expression. Currently we don't provide Previous aggregate/function. Still if you elaborate on your scenario we may be able to provide you with a suitable solution.

Regards,
Peter
Telerik
 

Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

 
0
Dinakaran
Top achievements
Rank 1
answered on 06 Jan 2017, 11:06 AM

Hello,

        I am trying to get next row value in conditional formatting. Is it possible to get next row value in conditional formatting?

0
Stef
Telerik team
answered on 06 Jan 2017, 01:28 PM
Hello Dinakaran,

Getting exactly the next record in an expression is not supported.

Conditional formatting rules
are based on data fields. You can execute calculation on the current data scope or an upper scope by using the built-in Data functions (Data scope related functions).

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Roland
Top achievements
Rank 1
Answers by
Peter
Telerik team
Dinakaran
Top achievements
Rank 1
Stef
Telerik team
Share this question
or