• State Not Answered
  • Replies 2 replies
  • Subscribers 11 subscribers
  • Views 189 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Interface read only grid

Kiran Sajjan
Certified Associate Developer
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

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

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

Reply
  • 0
    Certified Senior Developer

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

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.