how to write if statment

[kunkumnaveen]

HI,

can any one says whats wrong in thisexpression,expression seem ok but i am getting  required o/p

if(FirstSortedValue( {<ROLE={'EVAL'} >}TOTAL_SCORE, -DATE_OF_REVIEW)=0,0,FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},SUPCAT=, >}TOTAL_SCORE, -DATE_OF_REVIEW))

thanks

naveen

[kunkumnaveen]

but i am not  getting  required o/p

[sunny_talwar]

May be this:

if(IsNull(FirstSortedValue( {<ROLE={'EVAL'} >}TOTAL_SCORE, -DATE_OF_REVIEW)), 0, FirstSortedValue(Distinct {<ROLE={'SELF_EVAL'}, SUPCAT=>}TOTAL_SCORE, -DATE_OF_REVIEW))