Home Academy Video tutorials

Combine statistical and financial data for better business insights

5:54 min
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

Phocas product
Phocas Software help and support
Help & support

Have questions or need to report an issue with a Phocas product?

Get support

Related video tutorials

Manage streams and scenarios
Financial Statements Financial Statements

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.

3:47 min
Bring statistical streams into a Financial Statements database
Financial Statements Financial Statements

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.

3:39 min
Review a customer profile
Sales Insights Sales Insights

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.

2:39 min
See margin next to every sale
Analytics Analytics

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.

2:02 min
NewSee the latest features, improvements and what's new in productView product updates