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
.
  1. For
    Field Name
    , enter "Tax Auth Rounded Amt".
  2. In the
    Functions
    : list, select
    Round
    .
  3. In the
    Formula
    section, select
    NumberFieldName
    , then
    Tax Auth Unrnd Amount
    .
  4. Replace
    Integer
    with "2". The formula build should show Round("Tax Auth Unrnd Amount", 2).
  5. Select
    Validate
    to verify the formula doesn't have any syntax errors.
  6. Select
    Create Field
    .

Related content