Working on the following code:
if
(
(
([Query2].[Quote Status]= 'Quote Open') or
([Query2].[Quote Status]= 'Quote Completed') or
([Query2].[Quote Status]= 'Prospect')
)
and
(
[Query2].[Revenue Start Date]< Today()
)
)
else
if ([Query2].[Quote Status]= 'Quote Completed' and [Query2].[Revenue Start Date] is null)
If above code is satisfied, a cell in a table is given a background color. But I am getting a parsing error. I tried to do away with if else but still is not working. When I didn't get any error, I think it was not taking the "[Query2].[Revenue Start Date]< Today()" because the code was only satisfying the quote status and not the date.
Ok, I'll start off by doing a bit of simplification, just to make your statement a bit more readable (to me at least)
if([Query2].[Quote Status] in)'Quote Open', 'Quote Completed', 'Prospect') and [Query2].[Revenue Start Date]<Current_date)
then (you need an output here)
else
if([Query2].[Quote Status]= 'Quote Completed' and [Query2].[Revenue Start Date] is null) then (you need your 2nd output here)
else (your third output goes here)
Essentially, you're missing a good chunk of what you need for your if...then...else to work
Attached image shows what I am trying to do. If the if else is satisfied then use red color. If the style needs to be added in the if else statement then I will try to do it that way.
This issue is resoved. I was able to understand and use Condition Explorer for this. Thank you for the help.