Reports

Gen 3

Reports

Define Rules for your data: Computed Column

The Computed Column rule allows you to create new columns based on mathematical expressions. These mathematical expressions will often reference other columns in your report.

BriteCore supports the following mathematical operators:

  • %
  • &
  • (
  • )
  • *
  • +
  • /
  • days
  • months
  • weeks

Example expressions

  • Total Payoff Amount = Premium Payoff Amount + Custom Fee Payoff Amount + System Fee Payoff Amount
  • Net Written Premium = Item Written Premium * 0.63157894
  • Property TIV = Coverage A Limit + Coverage B Limit + Coverage C Limit + Coverage D Limit + Coverage E Limit + Coverage F Limit
  • Days Outstanding = Date Reported + 30 Days