I have 2 tables with a common key. When I link these 2 tables (On common field, Not join), the values are shown correctly. However when I join these 2 tables (irrespective of the joins used), the values are multiplied..
common key is
Business_Year&'_'&Business_Month As YearMonthKey ------- Sheet A
B_Year&'_'&B_Name As YearMonthKey ------- Sheet B
op : Sum(Fin_Amt) where Fin_Charge=EDC Charges = 751273 (Calculation in Data Load Editor Only )
of course it will not give you 3912.88 if you join it because both of your tables on different granularity. In one table you have storeid now if you will join fin amount will be repeated against all storeids which will give you 3912.88 * (number of storeid) = 751273