Color Condition with Months

[#1]

Hi,

I don't know how far off I am but I want to use the Background Color condition of a Dimension to display Red if the Salesman has worked at our company for less than six months and green if the Salesman has worked at the company for longer. What I have is:

if( Month(Start_Date) > MonthStart(Today(- 6)), RGB(200,0,0), RGB(0,200,0))

Please could someone assist me to fix the condition so that it displays the correct colors.

Thanks,

Shane

[maneshkhottcpl]

Hi,

I have go through the application , according to me u need to change the expression in Chart for counting.

use following

=if(COUNT(if(Salesman <> 'Other' and Salesman <> 'Auction' and Salesman <> 'Branch management' and Salesman <> 'Branch Manager',SMD_KEY))<1,'-',COUNT(if(Salesman <> 'Other' and Salesman <> 'Auction' and Salesman <> 'Branch management' and Salesman <> 'Branch Manager',SMD_KEY)))

Also attached the application which is showing correct value.