Crystal Reports for Eclipse Designer Guide

Effect (rate, nCompoundingPeriods)

Description
Effect returns the effective annual interest rate based on the specified interest rate and the given number of compounding periods.
Arguments
  • rate is a number that specifies the annual interest rate.
  • nCompoundingPeriods is a positive number that specifies the number of compounding periods per year.
  • Returns
    Number value
    Action
    Effect returns the effective annual interest rate based on the specified interest rate and the given number of compounding periods.
    Examples
    Suppose you have a savings account that is advertising at 5% annual interest rate and pays interest monthly.
    Effect (0.05, 12)
    Returns 0.0512 (rounded to four decimal places) which corresponds to an effective interest rate of 5.12%.
    Comments
    This function is designed to work like the Excel function of the same name.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/