Formula Derived Item - Advanced
Advanced settings control portal presentation, repeated-date processing, and the Formula Derived Item's behavior in actuarial valuations.
- Basic Portal Settings:
- Display: Determines whether and when the item is calculated and displayed on the portal.
- Display Index: Controls the item's ordering among displayed items.
- Portal Caption: Label displayed with the value.
- Group Name: Places the item in the named portal group.
- Zero Values: Controls portal presentation when the formula result equals zero.
- Graphs:
- Graph Type: Selects the graph presentation used for this Formula Derived Item on the Portal.
- Graph Start: Selects the starting point for the values displayed in the graph.
- Frequency: Sets the interval between the values shown in the graph.
- Anniversary: Selects how the recurring graph dates are determined, with Month and Day specifying the calendar date when a fixed anniversary is used.
- Color: Selects the color used to display this item in the graph.
- Portal Amount Display:
- Category: Formats the value as General, Number, Currency, or Percentage.
- Decimal Places: Sets the number of decimal places displayed.
- Use 1000 separator (,): Displays a thousands separator in the amount.
- Symbol: Selects the symbol used with the displayed amount.
- Negative Numbers: Selects the display format for negative amounts.
- Convert to text using: Displays the title returned by the selected Text Conversion Definition or supported key mapping instead of the numeric result.
- Calculation Optimization:
- Do not process additional calculation dates: Reuses the result when a calculation evaluates the item across multiple calculation dates. Applicable only when the formula is invariant by calculation date.
- Do not process additional account dates: Reuses the result across multiple account dates. Applicable only when the formula is invariant by account date.
- Do not process if: Skips the formula when the selected Formula Derived Item satisfies the configured comparison and value.
- Actuarial Valuation:
- Do not allow dates past Valuation Date for VBO: When Vested Benefit Obligation is being calculated, caps the formula's calculation date and payment start date at the valuation date.
- Round all dates to nearest birthday: During valuation calculations, rounds dates referenced within the formula to the nearest participant birthday.
- Benefit Base (optional): Optional formula representing the benefit base for this item. Component attribution can re-evaluate the base and implied rate at the applicable measurement dates.
- Unit Credit Liabilities: Controls Formula Derived Item dates during UC calculations. No dates may go past valuation date caps the calculation and annuity commencement dates at the valuation date. Calculation date extends beyond valuation date allows the calculation date to follow the projected evaluation date.
Related Topics