COLOR CODEING NUMBER

[#1]

How do you do a color code like below I know how to use?

The numbers are averaged for wait times

Color code in brackets 1 - 5 red 6-8 green 9 and over yellow

[#2]

example of the expression I an trying to use.

if((Avg(ActualLeaveTime-ScheduledLeaveTime))>0, rgb(255,0,0), RGB(50,230,68))

[sunny_talwar]

So this expression isn't working for you? Does it do anything?

[#4]

I cant figure out how to do brackets when its on average time late example 0:30 late or 0:31 thru 1:00 hr.1:01 thru 2:00

[sunny_talwar]

May be like this:

If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(0, 30), Color1,

If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(1), Color2,

and so on...

[#6]

ok I can get the first line working but it errors out on the second line

below works but when I add the comma and release the second line error in expression

If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(0, 30), Color1

//If(Avg(ActualLeaveTime-ScheduledLeaveTime) < MakeTime(1), Color2,

[sunny_talwar]

Did you use Color1 or an actual color expression like Blue() or RGB(0,0,255)? You need to use a color in place of Color1 in the above expression

[#8]

RBG color

[sunny_talwar]

This should work, can you share a screenshot of where you are seeing the error?

[#10]

The first one works but need three colors