Unanswered

jOIN IN TWO TABLE

Like (1) Share

Report

Posted on 4 Jul 2024 08:26:25 by Giovanni1

Hi, I need your help... I have to calculate the total, but only of the sales movements, therefore excluding the other movements. I have two tables: TESDOCUM where I have all the document types and the value of each of them, but I only need to take the sales and to do this I should do a join with the TIPODOCU table, in which I could do the join with the Code column and the Tipoprotoc of the TESDOCUM table, but I need to filter through TIPODOCU only those that have VE in the column, to then calculate the sale. I also attach a part of the code, but this part is missing. Sum( Filter( TESDOCUM; DATAPROTOC = Data_1.Text And MAGAZZINO = ThisItem.MAGAZZINO ); USR_TOTDOC ) I hope for your help. Thanks in advance

Categories:

General Questions

All responses (7)

Answers (0)

Giovanni1 on 04 Jul 2024 at 16:38:53

Like (1)

Report

Re: jOIN IN TWO TABLE

yes the data is present
DBO_DV 4,665 Super User 2025 Season 2 on 04 Jul 2024 at 13:31:07

Like (1)

Report
Re: jOIN IN TWO TABLE

The message will always display.

could you check if there is Data inside the created Collection :
colCODICE
Giovanni1 on 04 Jul 2024 at 13:28:35

Like (1)

Report

Re: jOIN IN TWO TABLE

Unfortunately, even with this attempt the message is the same. Does not display any results
DBO_DV 4,665 Super User 2025 Season 2 on 04 Jul 2024 at 11:15:42

Like (1)

Report
Re: jOIN IN TWO TABLE

Hey @Giovanni1 ,

try this:
//In a Button or onChange OnVisible ClearCollect(colCODICE; Filter(TIPODOCU; CAUSALE = "VE").CODICE);; // Sum( Filter( TESDOCUM; DATAPROTOC = Data_1.Text And MAGAZZINO = ThisItem.MAGAZZINO And TIPOPROTOC in colCODICE // MAybe you'll need to add a .Value ); USR_TOTDOC )
The error that you've got was a Delegation warning. This is a Workaround to this warning. It will still appear but it will not falsify your results like this.
anandm08 1,936 Super User 2024 Season 2 on 04 Jul 2024 at 09:28:44

Like (1)

Report

Re: jOIN IN TWO TABLE

@Giovanni1 can't understand the warning message not in english.
Giovanni1 on 04 Jul 2024 at 08:51:29

Like (1)

Report

Re: jOIN IN TWO TABLE

I have this message
anandm08 1,936 Super User 2024 Season 2 on 04 Jul 2024 at 08:28:45

Like (2)

Report
Re: jOIN IN TWO TABLE

hi @Giovanni1 ,
you can use this code:
Sum( Filter( TESDOCUM, DATAPROTOC = Data_1.Text And MAGAZZINO = ThisItem.MAGAZZINO And TIPOPROTOC in Filter(TIPODOCU, CAUSALE = "VE").CODICE ), USR_TOTDOC )