Hi,
I am quite new to Cognos. I wanted to write a query in the Expression Definition.
I have 4 columns:
Type, Initial , Date, Amount
The condition is:
If 'Type' is X or Y
and if there is an 'Amount' one day prior to the 'Date'
then 'Initial' should be 'NO' Else 'YES'.
Kindly provide me the query for this.
Thanks,
acn
Quote from: nac on 18 Jun 2015 08:41:48 PM
Hi,
I am quite new to Cognos. I wanted to write a query in the Expression Definition.
I have 4 columns:
Type, Initial , Date, Amount
The condition is:
If 'Type' is X or Y
and if there is an 'Amount' one day prior to the 'Date'
then 'Initial' should be 'NO' Else 'YES'.
Kindly provide me the query for this.
Thanks,
acn
This is a duplicate of another post for which you were already given answers.
http://www.cognoise.com/index.php/topic,28269.msg90742.html#msg90742
Please read the Forum Etiquette:
http://www.cognoise.com/index.php/topic,24030.0.html