Expression Definition

[nimishabrahamc]

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

[Lynn]

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