2 Replies Latest reply: Apr 18, 2016 7:28 AM by Sunny Talwar RSS

    how to write if statment

    naveen kumar

      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