11 Replies Latest reply: Nov 14, 2012 4:35 AM by 973915 RSS

    EXPERTS PLEASE HELP ME IN CASE STATEMENT

    973915
      hi,

      The following is the table structure that i have in the backend

      cntry role name
      usa ss rambo
      usa ss java
      usa lsm jj
      usa lsm kk
      usa ps ll

      when i use the below case statements in two different column formulas
      case when role='ss' then name end
      case when role='ps' then name end

      i get


      CNTRY (CASEWHENROLE='SS'THENNAMEEND) (CASEWHENROLE='PS'THENNAMEEND)
      USA rambo
      USA
      USA
      USA ll
      USA java



      But what i need is
      CNTRY (CASEWHENROLE='SS'THENNAMEEND) (CASEWHENROLE='PS'THENNAMEEND)
      USA rambo ll
      USA java


      Can some one help me??