Skip to Content
avatar image
Former Member

Webi conditions

Hi,

I am trying to satisfy AND condition. Doesn't seem to work. Here's my scenario.

I have an ID that has A and B. If the ID has both A and B then Yes else No.

Hope this makes sense.

Thanks

Veena M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 02, 2016 at 08:55 PM

    Hi,

    Post your formula that you are trying.

    Usually you can do using IF condition

    =if ((ID) inlist ('A';'B');"Yes";"No")

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 10:58 PM

    Hi Veena,

    Do you mean if an ID has both characters A and B in it? Like from the list of values AB001, AB002, BC001, ACD01, ABD02 - the first 2 values would satisfy your condition, as those IDs have both the character AB in them. If you want to see flag such values, use the below formula.

    =If(Match([ID];"*A*B*")) Then "Yes" Else "No"

    (this formula to be used to flag any value that has characters A and B together or if there are any other characters between them, as we've an * (asterisk) between them)

    =If(Match([ID];"*AB*")) Then "Yes" Else "No"

    (this formula to be used to flag any value that has characters A and B together, as we don't have a * (asterisk) between them)

    Let us know if that works.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded