Hi all,
currently working with Application Express 19.1.0.00.15.
I have an Interactive grid in which I use the standard Aggregate function to sum up Cout avant taxes (cost before taxes) amounts and this works fine as shown below.
In some cases I needed to highlight the Cout avant taxes amounts when the total amount was higher than the budgeted amount this also worked fine to a certain extent.
I am using the following code snippet I pulled out of the IG Cook Book combined with PL/SQL case where the color is set.


It appears though that the function is getting in conflict with the aggregate function and the total amount no longer appears.
Am I doing anything wrong?
Any comments, tips, suggestions are greatly appreciated as usual.
Thanks,
Jake