I have two tables - Banner and Supplier, Both of them linked through click id, that is default association based on same name.
I have units field in Supplier table, I am getting very weird result while performing sum (units). Attached the image.
In straight table and in text box i am getting 4 as sum of unit, while when i see the table box for supplier there is only 1 record which has units 2. So how come it is giving me 4. Is there cross join happening that is not visible.
Please look into the image and let me know your thoughts.