This article applies to:

Create a formula in a custom report

This is an example of how to create a text formula that returns rounded tax amount for an authority where an unrounded amount's available.

note

Labels for fields and measures must be in double quotes (").

Text must be in single quotes ('):'--'.

Levels must be in single quotes (').

Before you being building the formula, make sure you select Show arguments in formula
.

For Field Name
, enter "Tax Auth Rounded Amt".

In the Functions
: list, select Round
.

In the Formula
section, select NumberFieldName
, then Tax Auth Unrnd Amount
.

Replace Integer
with "2". The formula build should show Round("Tax Auth Unrnd Amount", 2).

Select Validate
to verify the formula doesn't have any syntax errors.

Select Create Field
.