Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mulitple Conditions (at row level)

Hello  -   I have a situation where we have Orders that have different codes.   Sometimes just one code.   Sometimes multiple.     I would like to define a column that looks at each row, evaluating...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

 

A simplified example of the source data would be  (and the expected result in the last column)

 

RMA Order #      Hdr Prob Code              Single or Multiple    

 1234A                      T1                                    Multiple

 1234A                      T2                                    Multiple

 1234A                      T3                                    Multiple

 3458A                      T1                                    Single

 

So, in this example, because RMA Order 1234A is listed three times, each with a different Header code, this Order would be defined as "Multiple".   

 

Order 3458A only shows up once, with one Header code, and would be defined as Single.  

 

Does that help?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Single or Multiple Codes = IF(CALCULATE(COUNTROWS(Flu_RMAs), FILTER(Flu_RMAs, Flu_RMAs[RMA Order #] = EARLIER(Flu_RMAs[RMA Order #])),FILTER(Flu_RMAs, Flu_RMAs[Hdr Prob Code] <> EARLIER(Flu_RMAs[Hdr Prob Code]))) > 1, "Multiple", "Single")
  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Create a new column like. Add condition to filter

    Flag = if( countX(filter(table,table[RMA Order #]=earlier(table[RMA Order #])),table[RMA Order #])>1,"Multiple","Single")

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Ricky  -   Thanks for your help.... I get the red squiggly line error right at the very end....(see bolded text).    It says it is an "unexpected parameter" error.  

     

    Single or Multiple Codes = IF(CALCULATE(COUNTROWS(Flu_RMAs), FILTER(Flu_RMAs, Flu_RMAs[RMA] = EARLIER(Flu_RMAs[RMA],FILTER(Flu_RMAs,Flu_RMAs[Hdr Prob Code] <> EARLIER(Flu_RMAs[Hdr Prob Code]))) > 1, "Multiple", "Single")

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Check the Data type of your column:

      Column Tools --> Data Type: Text

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Ricky    -    Just to clarify, I don't already have a column with these values in it  (Single or Multiple).    This is what I am trying to create.  

         

        So just to state my example again, I have a table that list all of our orders  (RMA order).     In this table, there is a field called Hdr Prob Code.     This table is for Orders that have returns....issues....and the Prob Code is a code that defines what the issue is.   

         

        Some orders can have multiple problem codes.     Some orders just have a single problem code.   

         

        I need to be able to distinguish which orders are "Multiple"   or  which orders are  "Single"   in terms of how many problem codes are associated with a particular order.     Example: 

         

        Order #      Prob Code         Single or Multiple  

        1234A            T2                        Multiple

        1234A            T3                        Multiple

        3456A            T2                         Single

         

        So, in this example, Order 1234A appears on two different rows....each with a different problem code....so it gets defined as having "Multiple" problem codes.       Order 3456A just appears on one row, and just has one problem code....so it is defined as "Single".