Print Page - Inserting new field by comparing the value of two existing fields

Title: Inserting new field by comparing the value of two existing fields
Post by: naveen10046 on 09 Mar 2010 08:18:29 PM

Hello all,
I have a scenario ,where I need a new field to be inserted in my list report which should display 'passed' or 'failed' based on the comparison on the two existing fields.

Existing Fields
1)mark secured
2)pass mark

Title: Re: Inserting new field by comparing the value of two existing fields
Post by: vinu on 09 Mar 2010 10:47:30 PM

Try below,

Calculate new data item with below condition and insert in to Report.

If (Mark Secured>=PassMark) then 'Passed' Else 'Failed'

HTH,
Venu

Title: Re: Inserting new field by comparing the value of two existing fields
Post by: naveen10046 on 16 Mar 2010 12:02:59 AM

Thanks. ;D

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen10046 on 09 Mar 2010 08:18:29 PM