Inserting new field by comparing the value of two existing fields

[naveen10046]

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

[vinu]

Try below,

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

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

HTH,
Venu

[naveen10046]

Thanks. ;D