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
Quote from: krishnan on 03 Sep 2014 06:17:15 AM
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?
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