Forum Discussion

patrick3's avatar
patrick3
Helper II
7 years ago
Solved

Return Value based on Multiple Distinct Values in different column

Hi all,   I have unique ID's with multiple payment types - I'm trying to write a formula that'll look at the different values for each ID and return the same value for both rows - i.e. if one ID ha...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    See if this works:

     

    Column = 
VAR __table = FILTER(ALL('Table18'),[Unique ID] = EARLIER([Unique ID]))
RETURN
SWITCH(TRUE(),
    CONTAINS(__table,[Payment Types],"Payment Scheme"),"Payment Scheme",
    CONTAINS(__table,[Payment Types],"Invoice"),"Invoice",
    CONTAINS(__table,[Payment Types],"Standard"),"Standard",
    [Payment Types]
)

    Table 18 of attached.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

See if this works:

 

Column = 
VAR __table = FILTER(ALL('Table18'),[Unique ID] = EARLIER([Unique ID]))
RETURN
SWITCH(TRUE(),
    CONTAINS(__table,[Payment Types],"Payment Scheme"),"Payment Scheme",
    CONTAINS(__table,[Payment Types],"Invoice"),"Invoice",
    CONTAINS(__table,[Payment Types],"Standard"),"Standard",
    [Payment Types]
)

Table 18 of attached.