Skip to main content
K
kirans0126
June 17, 2024
Question

Interface read only grid

  • June 17, 2024
  • 2 replies
  • 0 views
Student Student Year  Subaject A score
Student1 2021 100
Student 2 2021 100
Student 3 2021 100
Student1 2022 90(-10)
Student 2 2022 80(-20)
Student 3 2022 70(-30)
Student 1 2023 95(+5)
Student 2 2023 70(-10)
Student 3 2023 78(+8)

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

    2 replies

    venkatrea696188
    venkatrea696188
    June 17, 2024

    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)
),")"
)
)

    stewart.burchell
    stewart.burchell
    June 17, 2024

    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.

    Terms & ConditionsAccessibility statement