Click here to Skip to main content
15,890,995 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to write a scaler value function for get Interest and Principal Amount of particular Installment from Given EMIAmount,RateOfInterest,LoanPeriod and Principal Amount like
P=100000 (Principal Amount)

I=10 (IntrestRate)

T=24M (LoanPeriod)

EMI=4614.49 (EMIAmount)

Installment No. : 7 (EMINumber)

how to get Interest of 7th EMI from scaler value function

output should be : 640.29

please share formula or code


What I have tried:

i get this from temp table but scaler value function not allowed create table
Posted
Comments
Richard MacCutchan 11-Jun-18 8:56am    
You have to do some calculations on the different values.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900