Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Gross Profit Margin

Hi: For Microsoft Dynamics 365 Business Central, I'm using the Chart of Accounts table and I'd like to calculate gross profit margin by subtracting cost of goods sold from revenue and dividing that ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    If they are coming from two tables

    calculate(divide((sum(Table2[revenue])-sum(Table1[COGS])),sum(Table2[revenue]))

     

    From one table

    calculate(divide(sumx(Table[revenue]- Table[COGS]),sum(Table[revenue])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous ,

If they are coming from two tables

calculate(divide((sum(Table2[revenue])-sum(Table1[COGS])),sum(Table2[revenue]))

 

From one table

calculate(divide(sumx(Table[revenue]- Table[COGS]),sum(Table[revenue])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, for responding!

    This still doesn't work, really. 

    The following is what my report currently looks like, and the table is called Chart_of_Accounts.  If you can please modify your answer, that would be awesome!  ðŸ˜€

    Account Category     Balance     Account No

    Cost of Goods Sold   500000     50000

    Income                      700000     40000

    Income                        20000     41000

     

    John