Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.