Background colour on Total row based on content`

[#1]

I have a requirement to show if a sales rep has a zero sales forecast for a period. All the individual companies are shown,along with some other data, in a straight table, including the forecast amount. If all the forecasts total $0, I want to set the background colour of the "Total" row ONLY to red.

I know I can colour the row regardless with "If (rowno()=0 or rowno()=Null", but I want to colour it based on the value.

Is this what the 'below' function does? The documentation is very poor.

Thanks,

Kevin

[Oleg_Troyansky]

You need to use the function DIMENSIONALITY().

Dimensionality() = 0 represents the total row.