Number colour formatting in set analysis

[traceycurran]

Hi

I have an expression :-

Num($(vRevenueMonth)-$(vBudgetMonth),'##,##0;(##,##0)') 

this works but I want the negative numbers to also appear in red and the positive to be green.

I can't work out where or how I need to insert red() and Green()

Thanks in advance

TC

[Gabriel]

Hi,

Which object are you using to display the result of your expression?
As in are you using KPI, Table or Pivot table object

[traceycurran]

Hi

I'm using a table

I tried to set the colours using limits and indicators (see below) but it doesn't  follow through to the totals.  I thought set analysis might be the answer

Thanks Tracey