Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As per the expression shown below, it produces percentages. I need to assign back ground colour where percentage grater than 10% or less tan -10% to be assigned with red if not green. But the results are not produced as expected. I have used ' OR function & percentage just marked as 10 & -10. Due to what error it could be?
Thanks
Neville
IF((SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-(SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT)))/(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT))-(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT))/SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)>10 OR (SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-(SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT)))/(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT))-(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT))/SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)<10,LIGHTRED(),LIGHT(GREEN)
It is not something like you need to use 0.1 and -0.1 for 10% & -10%?
Regards,
Chris.
It is not something like you need to use 0.1 and -0.1 for 10% & -10%?
Regards,
Chris.