Forum Discussion

Nikki's avatar
Nikki
Icon for Helper II rankHelper II
6 years ago

Contiene Fórmula

Hola tengo una serie de columnas personalizadas ejemplo: Concepto (el resultado es un error de paso o una consulta) Iniciativa (el resultado es error de paso o consulta) Proyecto (el resultado ...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

Tal vez intente algo como esto:

Status =
VAR FinalString =
    CONCATENATEX (
        FILTER ( Nikki, Nikki[Num] = EARLIER ( [Num] ) ),
        [Concept] & [Initiative] & [Project] & [Brief]
    )
VAR LowerString =
    LOWER ( FinalString )
VAR PassIncluded =
    SEARCH ( "pass", LowerString, 1, 0 )
VAR QueryIncluded =
    SEARCH ( "query", LowerString, 1, 0 )
VAR Result =
    SWITCH ( TRUE (), QueryIncluded > 0, "Query", PassIncluded > 0, "Pass", "Fail" )
RETURN
    Result

Nikki.PNG

Nikki's avatar
Nikki
Icon for Helper II rankHelper II
6 years ago

muchas gracias !!