Column not performing Calculation

Hi ratercero,

Is that the value of PROCESS_CATEGORY should be "OK" if t_Batch[DESCRIPTION] = "OK"?

If that is case, you may left a ResultTrue value for the condition if t_Batch[DESCRIPTION] = "OK".

IF ( t_Batch[DESCRIPTION] = "OK", ResultTrue, if(...))

Following is modified formula for your reference. :smileyhappy:

PROCESS_CATEGORY =
IF (
    ( t_Batch[DESCRIPTION] = "AB"
        || t_Batch[DESCRIPTION] = "LT"
        || t_Batch[DESCRIPTION] = "DA"
        || t_Batch[DESCRIPTION] = "RE" ),
    "WASHING",
    IF (
        ( t_Batch[DESCRIPTION] = "DM"
            || t_Batch[DESCRIPTION] = "RP" ),
        "REDYE",
        IF (
            ( t_Batch[DESCRIPTION] = "PM"
                || t_Batch[DESCRIPTION] = "PS" ),
            "MAINT",
            IF (
                ( t_Batch[DESCRIPTION] = "CC"
                    || t_Batch[DESCRIPTION] = "LP" ),
                "CE",
                IF (
                    t_Batch[DESCRIPTION] = "SB",
                    "REBLEACH",
                    IF (
                        t_Batch[DESCRIPTION] = "MT",
                        "READDS",
                        IF (
                            t_Batch[DESCRIPTION] = "CA",
                            "CA",
                            IF (
                                t_Batch[DESCRIPTION] = "OK",
                                "OK",
                                IF (
                                    t_Batch[PNC] <> "OK",
                                    t_Batch[PNC],
                                    IF (
                                        t_Batch[c_NumOfAdditions] > 0,
                                        "ADDITION",
                                        IF ( t_Batch[TIMES_PROCESSED] > 2, "MULTI-PROCESS", "OK" )
                                    )
                                )
                            )
                        )
                    )
                )
            )
        )
    )
)

Regards