Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- OneStream Community
- Resources
- Accepted Code Samples
- Finance: Gross Margin
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
OSAdmin
Valued Contributor
Options
- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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
Labels:
Community Resources
Training and Documentation
Additional Resources
