Forum Discussion

Grizman's avatar
Grizman
Icon for Helper I rankHelper I
9 years ago
Solved

Fields

I have two table:     which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1  
Need Help
  • Thyago_Rezende's avatar
    Thyago_Rezende
    8 years ago

    First picture below shows bi-directional relationship between tables. 

     

    Second picture shows measure for year 2016. 

     

    Hope help you. 

    Best regards,

Grizman's avatar
Grizman
Icon for Helper I rankHelper I
8 years ago

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's avatar
Thyago_Rezende
Icon for Resolver I rankResolver I
8 years ago

First picture below shows bi-directional relationship between tables. 

 

Second picture shows measure for year 2016. 

 

Hope help you. 

Best regards,

  • Grizman's avatar
    Grizman
    Icon for Helper I rankHelper I
    8 years ago

    Thanks a lot!