help regarding excluding values in if else

[INJAINP]

Hello folks,

My requirement is as below:

i have a field with codes 1 to 10. I want to create a column where if all codes are there then column should give answer as WITH and if values (7 or 8 or 9) are not there (means if codes has value 1,2,3,4,5,6,10) then column should give value as WITHOUT.

How to accomplish this ? is there any option to exclude values in If else?

Regards

Priyanka

[Anonymous · Accepted solution]

Hi @INJAINP,

You can refer to following formula to compare text value with list of records:

Result =
VAR list =
    GENERATESERIES ( 1, 10, 1 )
RETURN
    IF (
        COUNTROWS ( FILTER ( list, FIND ( [Value], [Code], 1, -1 ) > 0 ) )
            = COUNTROWS ( List ),
        "With",
        "Without"
    )

Regards,

Xiaoxin Sheng