Forum Discussion
Solved
Making calculation from 2 table with no relation but with same structure
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
hpandersen , You have to create a common date/ year table. Otherwise you can analyze only on and total
3 Replies
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.
hpandersen , You have to create a common date/ year table. Otherwise you can analyze only on and total
Hi.
Guess you are right. Was just hoping for a shortcut.
Thanks anyway.
