When reviewing saved search results, numeric percentages can be difficult to interpret quickly. A simple progress bar built using a Formula (HTML) field can significantly improve readability by adding a visual indicator directly in the results.
This technique is especially useful for tracking metrics like completion rates, utilization, or SLA performance. It leverages saved search formulas, which support calculated fields and formatted output as part of NetSuite’s analytics capabilities.
Important: This example is intended to demonstrate what is possible using saved search formulas. If you have experience with HTML and inline styling, you can extend this approach to create more advanced, dynamic, or visually refined progress bars tailored to your reporting needs.
Sample Result
Solution
Use a Formula (HTML) column in the Results to show a progress bar based on a calculated percentage.
Example Formula:
'<div style="display:flex; align-items:center;"> <div style="width: 120px; border: 1px solid #999; height: 12px; background: #f2f2f2; margin-right: 6px;"> <div style="width: ' || percentage_expression || '%; height: 12px; background: #4caf50;"></div> </div> <span>' || percentage_expression || '% </span> </div>'
Where percentage_expression should be replaced with:
- A field that already returns a percentage, or
- A formula that calculates a percentage (for example, completed / total * 100)
How It Works
- The inner <div> dynamically adjusts width using a percentage value
- The percentage is injected into both:
- The bar width (width: X%)
- The label (X%)
- The % symbol must be concatenated as a string for proper rendering
Notes
- This approach is best used for operational or KPI-style saved searches where users benefit from quick visual indicators rather than raw numbers.
- It works particularly well on dashboards and in scenarios where you are tracking progress toward a target, completion percentage, or utilization.
- Use aggregation functions like SUM() only in Summary Searches; otherwise use field-level calculations
- HTML rendering works in saved search results and some dashboard portlets, but may not display correctly when exporting results
- This is a formatting technique, not a native NetSuite visualization feature, so behavior may vary slightly by role or UI context
-----
If you find this information useful, let us know by reacting or commenting on this post!