Forum Discussion

Max_Broglia's avatar
Max_Broglia
Frequent Visitor
6 years ago

Media between Two Column in Matrix

Good Morning,

I've made a Matrix of a table of invoices like This.

In the last Column (Margin % on Revenues) I've to make the operation Margin (C) / Revenues (A) of the total invoices for company.... How Can I do That?

 

Tks a lot 

 
 
CompanyRevenues (A)Cost(B)Margin (C)Margin % on Revenues
Alfa1002080 
Beta1507080 
Gamma807010 

1 Reply

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Max_Broglia 

    its unclear now, but try smth like

    Margin % on Revenues = 
DIVIDE(CALCULATE([Margin (C)]), CALCULATE(SUM([Revenues (A)]), ALL('Table')) )

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution