Formatting the text color and format of an expression in a chart

[#1]

Hi,

I am trying to format my expression so that if the date is > 45 days in the past it will display in red.

Here is my expression:

min( {1<KPI_No={1000000008} >} last_upd_dttm_latest )

In the chart properties in the expressions tab I expanded the expression and went to text color.  I entered this:

=if(min( {1<KPI_No={$(=vKPINo_MPFPurch)} >} last_upd_dttm_latest )-45, Red(), Black())

The value is displaying red regardless if it meets the criteria.  In my example last_upd_dttm_latest = 3-sep-12 which means it shouldn’t be red.

I’m also trying to format the text to be bold.  I’ve tried this in the text format section:

=if(min( {1<KPI_No={$(=vKPINo_MPFPurch)} >} last_upd_dttm_latest )-45, '<b>')

But I’m not having any luck with this.

Any help would be greatly appreciated.

[MayilVahanan · Accepted solution]

Hi

Try like this,

=if(Num(today()) - Num(min( {1<KPI_No={$(=vKPINo_MPFPurch)} >} last_upd_dttm_latest) ) > 45, Red(), Black())

hope that helps

[#3]

Thanks so much - this is exactly what I needed.