Skip to content
REFERENCE

U.MAX_PRECISION

Summary

Manually sets internal flag that prompts U to round numeric values to a specified precision before publishing a report

Syntax

=U.MAX_PRECISION([max_precision], [ignore_dates], [metadata])

Parameters

Parameter Required Description
[max_precision] No The number of decimal places to which numbers should be rounded. A default of 8 is applied if not specified; a min of 0 and a max of 15 is enforced.
[ignore_dates] No If set to TRUE then values will be rounded even if they are within a range that makes them look likely to be an Excel datetime.
[metadata] No Additional metadata to be applied to report being published; can be selected from multiple ranges. If specified this metadata is combined with the max_precision metadata into a single list of metadata entries; set to "global" to apply max precision to all publishes

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.MAX_PRECISION(2)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.