Forum Discussion

INJAINP's avatar
INJAINP
Frequent Visitor
7 years ago
Solved

help regarding excluding values in if else

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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