How to Compare the data

[krishnan]

hi,

i have a dataset

Id    Country
1       India
1-a   Usa
2   Usa
2-a   Usa

Now my report should be in the below format


Id    Country   result
1       India   n/a
1-a   Usa   fail
2   Usa   n/a
2-a   Usa   pass

when the country differs then it should show fail when the country is similar it should show pass

how to achieve this in cognos

[Lynn]

hi,

i have a dataset

Id    Country
1       India
1-a   Usa
2   Usa
2-a   Usa

Now my report should be in the below format


Id    Country   result
1       India   n/a
1-a   Usa   fail
2   Usa   n/a
2-a   Usa   pass

when the country differs then it should show fail when the country is similar it should show pass

how to achieve this in cognos

Differs from what? Is similar to what?

[krishnan]

i want to compare the value 1-a with 1 and if the country differs from 1 then we have to mark it as fail if 1 and 1-a are same then we have to make it as pass