Add calculation and measure columns
2:47 min
.png?width=880&name=thumbnail%20(9).png)
Learn how to enhance your analysis in Flex Modes by adding custom columns. Whether you’re creating calculation columns to build formulas like percentages and comparisons, or adding measure columns to bring in additional data such as counts, this feature gives you the flexibility to explore your data more deeply and uncover meaningful insights.
Supporting documentation
Phocas product 
Flex Modes
Flex Modes Category
Related video tutorials
Financial Statements Add custom columns to financial reports
If you have permission to customize statements, you can design your own version of a Profit and Loss statement and Balance Sheet statement by defining the columns that they contain, giving you much greater flexibility in the layout and analysis capabilities.
3:57 min
Insights Edit threshold sets for specific customer groups
Discover how to make your customer segmentation more accurate by using threshold sets. Learn how to customise thresholds for different groups and ensure your insights reflect how each part of your business performs.
2:00 min
Flex Modes Apply conditional formatting in Flex Modes
Learn how to use conditional formatting to quickly highlight key values in the grid. In Flex Modes, you can apply rules that change the text or background color based on cell values. It’s a great way to make trends and outliers stand out without needing to sort or filter.
2:22 min
Budgets & Forecasts Change the grid layout
Adjust the standard view of a budget or forecast worksheet to fit your analysis and reporting needs. Depending on your access, some rows may be hidden, but you can still tailor the layout in several ways to suit your preferences.
2:17 min
Analytics 
Rebates 
CRM 