Skip to Content
0

Non functional In statement

Sep 21, 2017 at 02:50 PM

26

avatar image
Former Member

Hi Gurus,

I would like to ask you for little help.

I want to mark the row , where is "Konso" in "Product" column and "Réalisé" in "state of request" column.

But I need variable, which give me that mark, when is "Cloturé" in "state of contract" column in any row (If there is no "Cloturé", then no mark)

All is in the "Client number" column (same value).

If I tried create "POKUS" column

=If([state of contract]="Clôturé" In([number of contract])) Then "1" Else "0"

and "POKUS2"column

=If ([state of request]="Réalisé" And [Product]="Konso" ForEach ([number of request])) Then "I" Else"O"

then

=If([POKUS]="1" In([Client number])) And [POKUS2]="I" Then "Yes" Else "No"

But this variables don't working

I also tried something like this:

If (([state of contract] InList("Clôturé") ForEach(number of contract)) And ([state of request]="Réalisé" And [Product]="Konsolidace" ForEach ([number of request])) In([Client number])) Then "Yes" Else "No"

(I need mark row with conditions and when is there "Clôturé" in table.)

4.png (25.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Sep 21, 2017 at 03:14 PM
0

try this.

=If (([state of contract] InList("Clôturé") or ([state of request]="Réalisé" And [Product]="Konsolidace" ) In([Client number])) Then "Yes" Else "No"

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

Thank you for your response, but this variable dont work. I need mark row with conditions (state of request]="Réalisé And [Product]="Konso"), only when is in [state of contract] column "Clôturé" for specific Client number. If there isn't "Clôturé", no mark at all.

0

Ok. have you tried this.

=If (([state of contract] InList("Clôturé") and ([state of request]="Réalisé") And ([Product]="Konsolidace" ) In([Client number])) Then "Yes" Else "No

0