Hi Everyone,
I need to achieve this in read only grid,
each consecutive year how much marks difference is there with the previous year need to be shown in the bracket
Thanks In Advance
Discussion posts and replies are publicly visible
Do you stuck Some where in particular? Use Concat function to show it on grid and as for the calculation create a rule which takes this years marks and previous Years marks as inputs and gives you the difference. You can directly calculate here itself but creating the rule is better option.
gridcolumn( label:"Marks", value:concat( fv!row.marks,char(32) ,"(",rule!Calculation(currentYearMarks:fv!row.marks, previousYearsMarks:data (Index using Student name and Year-1) ),")" ) )
It may be that there's an absolute requirement for the table to be laid out this way but it strikes me as being more readable to put Student on the Y-axis and Year on the X-axis and fill in the grid wit the relevant scores for Student/Year.