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.

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
.

This article applies to: