Jump to content

Search the Community

Showing results for tags 'amortization'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 1 result

  1. I've been trying to set triggers up to create a payment table for amortized loans. I'm able to get all the fields to work correctly except updating the principal amount paid each month. On the insert of a loan table, I'm creating a payment table based on the number of payments, loan loan amount and interest rate passed. I also pass the initial principal payment although it seems like I should be able to do the necessary calculation in the triggers. Most of the trigger works as expected buy I can seem to find the correct combination to correctly update the Principal Payment. I've tried various combinations and keep running into various errors when I try different ways. Please let me know what I'm doing wrong.
×
×
  • Create New...