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
i get this from temp table but scaler value function not allowed create table
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)