Hello there,
I have a Classic Report (based on function) and would like to add conditional highlight for a column.
The classic report is generated by an archive procedure, so the table will be expended every week with a new adding column of the most current week archive and there are for features of the weekly data and show in the rows. For example, week of 21-Sep, there are four features of data with four numbers 95%, 96%, 58%, 90% for 'Regression Test Run', 'Regression Test Pass', 'New Functionality (RCD) Run', 'New Functionality (RCD) Pass'.
My Question:
I would like to have conditional highlight for the most current week data only and the criteria is to compare data in this row (28-Sep) with Metric.
ex: 2nd row 'Regression Test Pass' Metric = '97%' and in column '21-Sep' = '97%', if the week data > = Metric, then as green (means meet metric). if week data < Metric, then marks as red (means NOT meet metric).
ex: 4th row 'New Functionality (RCD) Pass' metic = 95% and data is 89% of 28-Sep, then mark as 'Red'.
Basically, I only wanted the color highlight shows for the column of most current week
Expected Result looks like:
I know in dynamic action, there is a javascript option will allow you add color highlight based on condition. However, I am not JavaScript Savvy, so I am looking for Javascript expert can give me some hint here or show me an example to do that.
I have reproduced my example at apex.oracle.com
There access information is here:
Workspace: ALICE_DEMO
Username: alice_guest
Password: 54321
Any suggestion/help is much appreciated.
Thanks,
Alice