HomeUsing LincDoc 3.1+DANG Rule WizardAdvanced Calculations

10.9. Advanced Calculations

Certain calculations may entail multiple steps that require temporary fields to hold interim values. For example, a payment may be due on the last day of the month, but you may wish to schedule it for the day before.

In this case you need a variable field to temporarily store the end of month date. You can then use this field in the MinusDays function to calculate your final answer.

Creating a Temporary Variable

  1. Click the arrow button  to the right of the calculation's target field
    .
    The New variable dialog box appears.
  2. Type a name for the variable in the Variable name text box, and select the variable's type from the adjacent drop-down list.
  3. Select the new temp_EndOfMonth variable in the calculation's target field, and configure its calculation.
  4. Click the  button to the far right of the calculation's definition to create another calculation level.
  5. Complete the calculation of the pmt_dt field using the MinusDays method and the temp_EndOfMonth variable.

This page was: Helpful | Not Helpful