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

# If Conditon

Hi All,

i have the data like bellow :

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 ?

• ###### 1. Re: If Conditon

Hello Arrasyah,

{SUM(IIF([REFF_ID]=3,[TOTAL_VALUE],0))}>{SUM(IIF([REFF_ID]=11,[TOTAL_VALUE],0))}

Regards

Lei

1 of 1 people found this helpful
• ###### 2. Re: If Conditon

Hai Lei,

Thanks, its really help me out

• ###### 3. Re: If Conditon

Hi Arrasyah,

May i know how you are expecting the output ?

Regards,

Gopi

• ###### 4. Re: If Conditon

Hi Gopi,

I want to compare data no.3 and data no.11, if that condition true, then i'll put an arrow up, else arrow down.

Any other idea mate ?

Regards,

Arrasyah