IF Condition Help

[Raj_2]

Need a help on the IF condition, have attached my request in png file. I am stuck on this for long time. If it is one time then the reference from 1 & 2 based on non zero i need to update the output as 1 & 2 respectively otherwise it shall be blank.

Please help

Regards

Raj

[estherb47 · Accepted solution]

Hi Raj,

I'm not sure I'm understanding your request. Would you fill the table with the answers you desire?

Here's a go in any case

IF [One time]="One time" THEN

  IF [1]!=0 THEN 1
  ELSEIF [2]!=0 THEN 2

  ELSE ""

  ENDIF

ELSE ""

ENDIF

[Thableaus]

Hi @Raj_2

I understood the same thing @estherb47 did, I think the only change I'd make is to make sure to bracket the Fields 1 and 2.

Cheers,

[estherb47]

Whether to bracket the 1 and 2 depends on if you want to return the numbers 1 and 2 (no brackets) or the values in columns 1 or 2 (brackets)

[Raj_2]

Thank you Esther, it works

[Raj_2]

sorry i am looking for "1" not as {1} as header.

[Thableaus]

@Raj_2

Oh, ok, so I totally misunderstood what you wanted.

Glad the answer suits you, anyways.

Cheers,