join information from different tables

[acstaffa]

I need to produce a report that divide sales per labor day. I created a table wiht the information of the labor days quantity by month, but a I cant make the calculation.

I tried to join the amount of labor day in a new column in the sales table, but I couldnt find a relationship to bring it into.

any ideas?

[acstaffa · Accepted solution]

Hi, everyone. I solved it with the Lookupvalue and brought the information from on table into the other...
thaks

[acstaffa · Accepted solution]

Hi, everyone. I solved it with the Lookupvalue and brought the information from on table into the other...
thaks

[v-ljerr-msft · Accepted solution]

Hi @acstaffa,

Great to hear the problem got resolved! Could you accept your helpful reply as solution to help others who may also have the similar issue easily find the answer and close this thread?

Regards

[v-ljerr-msft]

Hi @acstaffa,

Could you post your table structures with some sample data and your expected result? So that we can better assist on this issue.

Regards

[Greg_Deckler]

Not without some sample data, very little to go on.