cancel
Showing results for
Did you mean:
Accepted Code Samples
OneStream approved sample code snippets and examples to help everyone write rules.

## Knowledge Base Articles

### Finance: Daily Revenue

An account that calculates Daily Revenue by taking three months of Total Revenue and dividing it down to a daily amount 'Calculate Daily Revenue 'Get Text1 priority from current Scenario to learn which Scenario to copy prior data from Dim priorScenar...

by Community Manager
• 61 Views
• 0 kudos

### Finance: Annualized Revenue

An account that calculates Annualized Revenue by taking three months of Total Revenue and dividing it down to a monthly amount then multiplying by 12 'Calculate Annualized Revenue Return api.data.GetDataCell("(A#TOTREV:I#Top:U1#Top:V#Trailing3MonthTo...

by Community Manager
• 82 Views
• 0 kudos

### Finance: Returned on Capital Employed

Efficiency Measure: A financial ratio that measures a company's profitability and the efficiency with which its capital is employed. Formula: EBIT/ (Total Assets- Total Liabilities) 'Calculate Return on Capital Employed 'Formula: EBIT/ (Total Assets-...

by Community Manager
• 46 Views
• 1 kudos

### Finance: Return on Total Assets

Efficiency Measure: The ratio is considered an indicator of how effectively a company is using its assets to generate earnings before contractual obligations must be paid. Formula: EBIT / Total Net Assets 'Calculate Return on Total Assets 'Formula: E...

by Community Manager
• 34 Views
• 1 kudos

### Finance: Return on Equity

Efficiency Measure: Return on equity measures a corporation's profitability by revealing how much profit a company generates with the money shareholders have invested. Formula: ROE= Net Inocme/ Average Shareholders Equity 'Calculate Return on Equity ...

by Community Manager
• 86 Views
• 1 kudos

### Finance: Return on Assets

Efficiency Measure: An indicator of how profitable a company is relative to its total assets. It gives an idea as to how efficient management is at using its assets to generate earnings. Formula: ROA = Net Income / Average Total Assets 'Calculate Ret...

by Community Manager
• 58 Views
• 1 kudos

### Finance: Receivables Turnover

Efficiency Measure: The receivables turnover ratio is an activity ratio, measuring how efficiently a firm uses its assets. Formula: Net Credit Sales/ Average Accounts Receivable 'Calculate Receivables Turnover 'Formula: Net Credit Sales/ Average Acco...

by Community Manager
• 43 Views
• 0 kudos

### Finance: Profit Margin

Efficiency Measure: The percentage of revenue remaining after all operating expenses, interest, taxesand preferred stock dividends (but not common stock dividends) have been deducted from a company's total revenue Formula: Net Profit Margin = Net Inc...

by Community Manager
• 42 Views
• 0 kudos

### Finance: Operating Margin

Efficiency Measure: Operating margin is a measurement of what proportion of a company's revenue is left over after paying for variable costs of production such as wages, raw materials, etc. Formula: Operating Margin = Net Income / Net Sales 'Calculat...

by Community Manager
• 41 Views
• 0 kudos

### Finanace: Net Profit Percent

Efficiency Measure: It reveals the remaining profit after all costs of production, administration, and financing have been deducted from sales, and income taxes recognized. Formula: Operating Profit/Sales or Operating Profit/Turnover Calculate Net Pr...

by Community Manager
• 50 Views
• 0 kudos

### Finance: Inventory Turnover

Efficiency Measure: The Inventory turnover is a measure of the number of times inventory is sold or used in a time period such as a year. Formula: COGS/ Average Inventory 'Calculate Inventory Turnover 'Formula: Cost of Goods Sold / Average Inventory ...

by Community Manager
• 48 Views
• 1 kudos

### Finance: Inventory period

Efficiency Measure: Inventory period is a measure of the average number of days inventory is held. Formula: Average Inventory/ (Annual COGS/365) or 365/ Inventory Turnover 'Calculate Inventory Period 'Formula: Average Inventory/ (Annual COGS/365) or ...

by Community Manager
• 55 Views
• 0 kudos

### Finance: Gross Margin

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 ...

by Community Manager
• 47 Views
• 0 kudos

### Finance: Average Collection Period

Efficiency Measure: The approximate amount of time it takes for a business to receive payments owed, in terms of receivables, from its customers and clients. Formula: Accounts Receivable/ (Annual Credit Sales/ 365) or 365/ Receivables Turnover 'Calcu...

by Community Manager
• 48 Views
• 0 kudos

### Finance: Asset Turnover

Efficiency Measure: The Asset Turnover ratio is an indicator of the efficiency with which a company is deploying its assets. Formula: Sales / Inventory 'Calculate Asset Turnover 'Formula: Sales / Inventory Return api.Data.GetDataCell("Divide(A#[YourS...

by Community Manager
• 33 Views
• 0 kudos

### Finance Business Rules: Helper SubEval

Initial lines of a Helper Business Rule Sub when written to support an Eval 'Substitute OnEvalDataBuffer for your Helper Sub name, evalName for the Eval statement being passed in and eventArgs for the Eval Data Buffer Args being passed in Private Sub...

by Community Manager
• 52 Views