KPI IDs Available for Scorecard Formulas
The following table lists the KPI IDs that are available for use in KPI scorecard formulas. For a description of each KPI, see Standard Key Performance Indicators Table.
|
KPI Name |
KPI ID |
|---|---|
|
Authorized Commission |
COMMISSIONS |
|
Authorized Partner Commission |
COMMISSIONSPARTNER |
|
Bank Balance |
BANKBAL |
|
Cart Abandonment |
CARTABANDON |
|
Cases Closed |
CLOSEDCASES |
|
Cases Escalated |
ESCALATEDCASES |
|
Checkout Abandonment |
CHECKOUTABANDON |
|
Closed Issues |
CLOSEDISSUES |
|
COGS |
COGS |
|
Credit Card Balance |
CREDITCARDBAL |
|
Custom KPI #1 |
CUSTOM |
|
Custom KPI #2 |
CUSTOM2 |
|
Custom KPI #3 |
CUSTOM3 |
|
Custom KPI #4 |
CUSTOM4 |
|
Custom KPI #5 |
CUSTOM5 |
|
Custom KPI #6 |
CUSTOM6 |
|
Custom KPI #7 |
CUSTOM7 |
|
Custom KPI #8 |
CUSTOM8 |
|
Custom KPI #9 |
CUSTOM9 |
|
Custom KPI #10 |
CUSTOM10 |
|
Deferred Revenue |
DEFERREDREVENUE |
|
Employees |
EMPLOYEES |
|
Equity |
EQUITY |
|
Estimated Commission |
ECOMMISSIONS |
|
Estimated Partner Commission |
ECOMMISSIONSPARTNER |
|
Expenses |
EXPENSES |
|
Fixed Assets |
FIXEDASSET |
|
Forecast |
FORECAST |
|
Forecast (Alt. Sales) |
FORECASTASA |
|
Forecast Override |
FORECASTOVERRIDE |
|
Forecast Override (Alt. Sales) |
FORECASTOVERRIDEASA |
|
Gross New Leads |
NEWLEADSGROSS |
|
Hosted Page Hits |
HOSTEDSITETRAFFIC |
|
Income |
INCOME |
|
Inventory |
INVENTORY |
|
Long Term Liabilities |
LONGTERMLIAB |
|
My Utilization |
UTILIZATION |
|
Net Cash Flow |
NETCASHFLOW |
|
New Business |
NEWBUSINESS |
|
New Business (Orders Alt. Sales) |
NEWBUSINESSORDALT |
|
New Business (Sales Orders) |
NEWBUSINESSORD |
|
New Cases |
NEWCASES |
|
New Customers |
NEWCUSTOMERS |
|
New Customers (Sales Orders) |
NEWCUSTOMERSORD |
|
New Issues |
NEWISSUES |
|
New Leads |
NEWLEADS |
|
New Opportunities |
NEWOPPORTUNITIES |
|
New Visitors |
NEWVISITORS |
|
Open Cases |
OPENCASES |
|
Open Estimates |
ESTIMATESRANGE |
|
Open Issues |
OPENISSUES |
|
Open Opportunities |
OPPORTUNITIESRANGE |
|
Open Prospects |
PROSPECTS |
|
Open Quotes |
ESTIMATESRANGE |
|
Operating Cash Flow |
OPERCASHFLOW |
|
Operating Expenses |
OPERATINGEXPENSES |
|
Opportunities Lost |
OPPORTUNITIESLOST |
|
Opportunities Won |
OPPORTUNITIESWON |
|
Orders |
ORDERS |
|
Other Assets |
OTHERASSET |
|
Other Current Assets |
OTHERCURRENTASSET |
|
Other Current Liabilities |
OTHERCURRENTLIAB |
|
Paid Commission |
PCOMMISSIONS |
|
Paid Partner Commission |
PCOMMISSIONSPARTNER |
|
Payables |
PAYABLES |
|
Payroll |
PAYROLL |
|
Pipeline (Alt. Sales Projected) |
PIPELINEASA |
|
Pipeline (Alt. Sales Weighted) |
PIPELINEWEIGHTEDASA |
|
Pipeline (Projected) |
PIPELINE |
|
Pipeline (Weighted) |
PIPELINEWEIGHTED |
|
Pipeline Deals |
PIPELINEDEALS |
|
Profit |
PROFIT |
|
Quota |
QUOTA |
|
Quota (Alt. Sales) |
QUOTAASA |
|
Quota Reps |
QUOTAREPS |
|
Receivables |
RECEIVABLES |
|
Revenue |
REVENUE |
|
Sales |
SALES |
|
Sales (Cash Basis) |
SALESCASHBASIS |
|
Sales (Orders) |
BOOKINGS |
|
Sales (Orders Alt. Sales) |
BOOKINGSALT |
|
Total Open Opportunities |
OPPORTUNITIES |
|
Total Open Quotes |
ESTIMATES |
|
Total Orders (Count) |
TOTALORDERS |
|
Total Pipeline (Alt. Sales Projected) |
TOTALPIPELINEASA |
|
Total Pipeline (Alt. Sales Weighted) |
TOTALPIPEWEIGHTEDASA |
|
Total Pipeline (Projected) |
TOTALPIPELINE |
|
Total Pipeline (Weighted) |
TOTALPIPEWEIGHTED |
|
Total Pipeline Deals |
TOTALPIPEDEALS |
|
Total Sales (Orders) |
TOTALBOOKINGS |
|
Unique Visitors |
VISITORTRAFFIC |
|
Web Orders |
WEBORDERS |
|
Web Revenue |
WEBREVENUE |
|
Web Site Hits |
SITETRAFFIC |
You can enter KPI IDs in a scorecard formula by selecting a KPI name from the KPI dropdown list in the scorecard's Formula popup window. Open this popup by clicking on the Set Formula icon that is available when you add a formula to the scorecard's KPIs subtab. For more information, see Defining KPI Scorecard Formulas.
If you include a custom KPI's ID in a scorecard's formula, you need to go to the scorecard's Custom subtab, and select a saved search in the corresponding custom KPI dropdown list there.
For an example of how to use formulas in KPI scorecards, check out NetSuite’s prebuilt Financial Ratios scorecard that is available to users with permission to see the Trial Balance report. You can review the formulas in this scorecard as examples. See Financial Ratios Scorecard Formulas.