Condional formatting - with calculated dimension

[alknirmal1]

Hi ,

I have a calculated dimension to calculate the age buckets for claims with respect to toddy's date in a block chart.

Calculated Dimension :

=IF((Today()-[Claim Received Date])>=-45 and (Today()-[Claim Received Date])<-15  ,'-45 to -15',

IF((Today()-[Claim Received Date])>=-14 and (Today()-[Claim Received Date])<-1  ,'-14 to -1',

IF((Today()-[Claim Received Date])>=0 and (Today()-[Claim Received Date])<=45  ,'0-45',

)))

Expression :

Count(Claim Number)

I have requirement of coloring the block chart with the below colors for each range.

0-45	Green
-14 to -1	Blue
-45 to -15	yellow

How can I achieve this requirement.?

I tried putting a background expression in the expression and its not working. What is the right way of doing  it ?

Appreciate your help on this.

Thanks

NV

[balabhaskarqlik]

May be:

You can specify format as #,##0.00;(#,##0.00) in chart properties on the Number tab

Or use Num function like Num(Your_Calc, '#,##0.00;(#,##0.00)')

By this it'll identify the positive & negative values.