OpenLayers mapping - using set analysis in the collour expression

[#1]

Hi all,

It appreas that the OpenLayers extension is not able to work with set analysis. Does anyone know how to get around this?

I want to use an expression similar to below. I have tried this in a table and the expression calculates fine, however it does not calculate in OpenLayers.

if((rank(sum({$<[Performance_Date]=>}total<[Group Name]> Hours)))<=31,rgb(44,27,69),

if((rank(sum(..... rgb(xx,xx,xx)....

Many thanks,

Isabel