Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
but i am not getting required o/p
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))