Hello Dear Team,
Good day!
I hope you're doing well. I'm reaching out to seek your help with an issue I've been struggling with for a couple of weeks.
I have an Interactive Grid (using Apex 24.2 version) that retrieves data using a SQL query. The data includes student_id, name, and their average marks (i.e., total marks obtained divided by the number of subjects) for each term — Term 1, Term 2, Term 3, and Term 4.
What I want to achieve is the following:
- For each student, I need to highlight in red the marks that are less than the class average for that term.
- I can calculate the class average per term using a PL/SQL function and store it in a hidden item for each term.
- Then, by comparing each student’s marks with the corresponding class average, I want the below-average values to be highlighted in red.
- This should happen automatically when the page loads or refreshes, without requiring the user to manually apply formatting through the action menu.
This feature is important so that teachers can easily identify students who may need extra support and give them more attention to improve their academic performance.
Could you please guide me on how to implement this? Sorry to say the suggestions got from AI tools like chatGPT and Gemini were unsuccessful. Any insights or suggestions would be greatly appreciated.
Thank you in advance for your kind support!
Best regards,
AR Kappil