03-25-2022 10:19 AM - edited 03-25-2022 10:27 AM
Efficiency Measure: The gross margin represents the percent of total sales revenue that the company retains after incurring the direct costs associated with producing the goods and services sold by a company. Formula: Gross Margin Pct = Gross Profit / Net Sales
'Calculate Gross Margin
'Formula: Gross Margin Pct = Gross Profit / Net Sales
Return api.Data.GetDataCell("Divide(A#[YourGrossProfitAccount], A#[YourNetSalesAccount])")
Source: Snippet Editor: Finance - Common Accounts - Efficiency Measures