I am in the midst of designing a line chart where i need to calculate the difference between some of the fields of the consequent rows.
For eg: The object data source have a field of datetime. I want to find the difference between the datetime of the first row data and the second row data.
More like , = First(Fields.DateTime) - Second(Fields.DateTime) . Where the second means the next row or second row.
I tried using PREVIOUS data function but it is not working in my telerik version. Unfortunately i cant find the correct expression to do this nor i can add a data field in the data level itself. Is there any expression to do this requirement ?
Thanks in advance