Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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())))