Sales CRM
Choose report measures and date periods correctly
Distinguish deal value, weighted value, averages and date bases so a report answers the intended question.
Where to start
Sales → CRM reports → Saved reports → Create report or Edit
Fields and options
- Access needed
- Sales CRM viewing access
- Permission and scope
- Sales CRM viewing access
Before you begin
Open the correct company workspace and confirm Sales CRM viewing access. Review the original record before following these steps. Open the relevant entry under the native Sales menu; the workspace tabs use shorter labels such as Deals, Reports, Relationships and Sales setup.
Follow these steps
- Choose Record count for the number of opportunities, Deal value for their total value, or Probability-weighted value for the sum of each amount multiplied by its probability and rounded to two decimals.
- Choose Average deal value, Average closed sales cycle or Average current stage age when an average is the intended measure.
- Select the date basis deliberately: created, updated, expected close, actual closed or current stage entry.
- Choose a relative calendar period or Custom dates. Preview the exact From and To dates shown in the result.
- For won sales in a period, use Actual closed date and Opportunity outcome = Won. For expected pipeline closes, use Expected close date and Opportunity outcome = Open.
Check the result
Read the measure, date label, exact date range and refresh time above the result. Use the contributing count when checking a closed-cycle average; it can be smaller than the matching record count.
If something does not look right
If a report differs from Forecast & targets, compare date basis, outcome, archive state and forecast-category filters before treating it as an error. An empty actual-closed report may simply contain only open opportunities. For a numeric value condition, select a currency when the threshold represents one currency’s commercial value.
Fields, rules and limits
- Monetary measures always separate currencies. There is no automatic conversion or sum across currencies. Counts and time averages can combine currencies because their units are records or days.
- Closed sales-cycle averages use whole elapsed days from creation to the actual closed date, including Won or Lost records with that date. Records without a closed date do not contribute to the average.
- Current stage age uses whole days from the current stage entry to refresh time. It is a current snapshot, not historical time spent in every prior stage. Choose Open outcome when analysing active stages.
- Last 30 and Last 90 days include today. Calendar month, quarter and year include their full calendar boundaries. Custom ranges support up to 367 inclusive days.
- Records without the chosen date do not fall into a bounded date report.
- Forecast categories do not implicitly exclude records from custom reports. Omitted, Won and Lost records remain eligible unless your filters exclude them. Weighted value is an arithmetic calculation, not a prediction or guaranteed revenue.
Related technical reference: Britixo's detailed product guide (opens in a new tab). The screens available to you depend on your configured modules, company and permissions.
Useful next steps
- Understand the Sales CRM workspace
- Create and preview saved CRM reports
- Filter reports with opportunity fields and conditions
Contact the Proplix team if you need help with your setup. Include the page or record reference and a description of the issue; leave passwords and private access tokens out of the message.