Forum Discussion
Grizman
Helper I
Helper IFields
I have two table: which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
GrizmanHelper I
Helper I
Thyago_Rezende
Resolver I
Resolver IYou must create a Bridge Table for relation both Table1 and Table2. A bridge table with PrimaryKey from id_Product and bi-directional relationship.
This article below, explain about pattern works for many to many relationship.
Regards,
- Grizman
I created bridge table Table 3 with one column id_product.
But I don't know how realize formula Q-ty*Price across thase table.
- Thyago_Rezende
First picture below shows bi-directional relationship between tables.
Second picture shows measure for year 2016.
Hope help you.
Best regards,
- Grizman
Thanks a lot!