Making calculation from 2 table with no relation but with same structure

[hpandersen]

Hi.

I need some advice.

I have 2 tables with no relations. But they have same structure:

Is there any way, I can make calculations as Divide(Table1.Period.Year, Table2.Period.Year). 

I would like to end up with a new table with same sturcture, but just showing the calculations.

Thanks in advance for your help.

Hans

[AnkitKukreja]

Hi! @hpandersen 

Agreed with @amitchandak here. I also, want to add either you can create a common date table or you can append your tables into 1.

[amitchandak · Accepted solution]

@hpandersen , You have to create a common date/ year table. Otherwise you can analyze only on and total

[hpandersen]

Hi.

Guess you are right. Was just hoping for a shortcut.

Thanks anyway.