If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional Style not working

Started by Universe, 08 May 2019 09:39:07 AM

Previous topic - Next topic

Universe

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.

BigChris

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

Universe

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.

Universe

This issue is resoved. I was able to understand and use Condition Explorer for this. Thank you for the help.