Combine statistical and financial data for better business insights
Learn how to use statistical streams in Financial Statements calculations with the STAT and AVG functions. STAT adds values over time, while AVG averages them, so you can calculate revenue per unit sold or operating profit per customer and compare performance across business entities.
Supporting documentation
Related video tutorials
Manage streams and scenarios
Learn how to use Manage Streams and Scenarios, also known as Combined Streams, to control which data appears in your statements. You'll set the default stream order for all users, create a scenario that combines streams such as actuals and allocations, and hide streams you rarely use.
Bring statistical streams into a Financial Statements database
Learn how to add statistical streams to a Financial Statements database in Designer so you can include non-financial information, such as units sold or customers, alongside your financials. You create each stream, mark it as statistical, assign a sync item, map the values, and build the database.
Review a customer profile
Learn how to review a customer's performance in their profile, from the summary and AI Summary to reorder and cross-sell opportunities. You'll also see how to open the data in Analytics and add a CRM activity, so you're ready for your next customer conversation.
See margin next to every sale
Learn how to see what you made, not only what you sold, by adding profit and margin next to sales in Analytics. Spot a dip in margin percentage over time, break it down by customer and month, and sort to find customers with negative margin. Then drill into the transactions behind them to help reps focus on worthwhile accounts and catch a bad discount early.