Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Sum non-repeating values

Good afternoon Community, I hope you are well. I have a report that needs a query whether or not a field contains a piece of text, example: I have this table with the values I want to look up...
amitchandak's avatar
amitchandak
Super User
5 years ago

Syndicate_Admin , based on what I got so far.

 

Create a new column in table 2

 

maxx(filter(Tabla1, search(Tabla1[clave], Tabla2[Commentarios],0,1)>0 ),Tabla1[score])

 

 

or like

 

sumx(filter(Tabla1, search(Tabla1[clave], Tabla2[Commentarios],0,1)>0 ),Tabla1[score])

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    Good morning , I hope you are well.

    Try to do it as in your comments, but it throws me an error :

    An argument of function 'SEARCH' has the wrong data type or has an invalid value.

    Greetings and thanks in advance.