Crystal Reports Looping

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Looping

Post Reply

Post New Topic

Author	Message
sheire Newbie Joined: 04 Jan 2011 Online Status: Offline Posts: 2	Topic: Looping Posted: 04 Jan 2011 at 7:45pm
	how to compute interest forecast (diminishing computation)? say: Loan balance = 450 monthly interest rate = 0.015 months remaining = 5 months what will be the code to compute the interest at the end of the term
	IP Logged


Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 05 Jan 2011 at 2:49am
	Assuming variables have been declared for i = 1 to monthsRemain do ( interestForMonth := (formula for calculating interest) totalInterest := interest + interestForMonth ); totalInterest Something like that. I don't know what the formula would be.
	IP Logged

sheire Newbie Joined: 04 Jan 2011 Online Status: Offline Posts: 2	Posted: 05 Jan 2011 at 2:05pm
	i was trying to declare variables and execute the code u gave but i cant do it i dont know how to declare variables. im new in crystal and im not a programmer either. please help
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 06 Jan 2011 at 2:39am
	If you can share the formula used to calculate monthly interest and how it is related to the loan balance (ie: maybe it's compounded monthly) then I could probably write the formula for you. Edited by Keikoku - 06 Jan 2011 at 2:40am
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum