Colour

[smilingjohn]

Hi ALl,

I want to set the colour and iam doing this under the expression then background

I have 4 classes .

Class A

Class B

Class C

Class D

And i want to show that if the countt of ticket for Class A and B is not equal to 0  and the Days are within 0to7 days then red else it should be Green

and if the the count of Ticket for Class A and Class B are  are greater than 5 and the days are 8 to 20 then Red else Green

if Count of ticket is above of 10 for class A and Class B for the days above 20 then it should be AMber else Green..

Iam trying to use this formula but this is not working ..

Can someone please sugget me on this

if(count({<Class={'Class A','Class B'},Days={0 -7}>}Ticket)<>0,Red(),Green())

please need help of the expertise....

Thanks in advace....

[Anil_Babu_Samineni]

It should like below?

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">=0 <=7"}>} Ticket) > 0, Red(),

  If(Count({<Class = {'Class A', 'Class B'}, Days = {">=8 <=20"}>} Ticket) > 5, Red(),

  If(Count({<Class = {'Class A', 'Class B'}, Days = {">20"}>} Ticket) > 10, RGB(255,194,0), Green())))