Skip to Content
0
Former Member
Mar 19, 2009 at 10:56 AM

ALERTERS

31 Views

Hi,

I am using Alerters as traffic lights to prompt team leaders where agents are hitting/missing targets etc.

I have got the logic/figures right with the way this is set, however I seem to be having a formatting issue.

Examples:

This example works fine, however the 11.6 entry is manually input and i want a variable to make this go Green/Red as the figure will change on a daily basis

Cell Contents - Greater than or equal to - 11.6 (calls per hour) = Green

Cell Contents - Less than or equal to - 11.6 (calls per hour) = Red

This Example does not work when pointing to a variable.

Cell Contents - Greater than or equal to - Hit Target(variable name) = Green

Cell Contents - Less than or equal to - Miss Target(variable name) = Red

Can someone please help me with this please!

Thanks very much.

p.s. points will be given Generously.

Kellyx