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.....
az38's avatar
az38
Icon for Community Champion rankCommunity 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