Forum Discussion

ratercero's avatar
ratercero
Helper III
9 years ago
Solved

Column not performing Calculation

Hello, I have  a column not performing the calculation for certain rows.

 

The formula is:

 

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",
				 IF( t_Batch[PNC]<>"OK",
                 t_Batch[PNC],
                 IF(
                     t_Batch[c_NumOfAdditions]>0,
                     "ADDITION",
					 IF(t_Batch[TIMES_PROCESSED]>2,
						 "MULTI-PROCESS",
                     "OK")))))))))))


It does not return "OK" for the last condition in all rows, here is a print screen:

 

 

 

 

Why is this happening?

 

Thanks in advance for the support.

 

RT

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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