Quarter and expression help

Thu, 02 Oct 2014 14:03:56 GMT

Hello,

I am trying to accomplish the following in a chart:

1. Status = In Progress and End Quarter has not passed , GREEN

2. Status = Not Started and Start Quarter has passed , RED

3. Status = In Progress and End Quarter has passed , RED

My start and end quarters are 1,2,3,4 in the database. How do I compare to current quarter?

I have this working so far

=if(Status='Not Started' and START_QUARTER>1,RGB(255,153,153), IF(Status = 'In-Progress',RGB(0,255,0)))

Can anyone suggest how to get three conditions working in one column?

Thanks.

Re: Quarter and expression help

alexandros17 — Thu, 02 Oct 2014 14:08:07 GMT

if(cond1, RGB(...),

if(cond2, RGB(...),

if(cond3, RGB(...)

, RGB())

)