4 Replies Latest reply on Oct 16, 2017 11:47 PM by Arrasyah Ilhamdani

    If Conditon

    Arrasyah Ilhamdani

      Hi All,

       

      i have the data like bellow :

       

      tbleauask1.JPG

       

      I want to create calculated field using if condition,

      where If TOTAL_VALUE REFF_ID no.3 is greater than TOTAL_VALUE REFF_ID no.11 then i want to set it into 'true' else 'false'

       

      Currently i'm using this formula :

       

      IF FLOAT([REFF_ID]='003') > FLOAT([REFF_ID]='011') THEN 'TRUE'

      ELSE ' FALSE'

      END

       

      And also this :

       

      IF

           CASE [REFF_ID] WHEN '003' THEN [TOTAL_VALUE] END

      >

           CASE [REFF_ID] WHEN '011' THEN [TOTAL_VALUE] END

      THEN 'TRUE'

      ELSE 'FALSE'

      END

       

      and the result wasn't like i expected.

       

      Is there any formula that i can use ?