Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use of intrest-calculation 1

Status
Not open for further replies.
yochai71

yochai71

Programmer
Oct 1, 2003
8
IL
To the forum-members

Use of intrest-calculation
I have to evaluate the following expression X*(Y^1+Y^2+Y^3….+Y^n)
X,Y and n are values in the record.
Does somebody have any idea how to solve this problem
Thanks,
Yochai

 
Sort by date Sort by votes
Such a dynamic calculation will not succeed with standard reporter functions where you can only define static expressions.
You may need to resort to VBA to loop through the values of 'n' to perform the calculation....

T. Blom
Information analyst
tbl@shimano-eu.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

t1sugar
  • Locked
  • Question
which version of crystal reports for boxi 4.1; Help 1
Replies
3
Views
556
hilfy
hilfy
PWD
  • Locked
  • Question
Financial Week Calculation
Replies
0
Views
161
PWD
PWD
PWD
  • Locked
  • Question
Count of Dates For Non-Unique Values
Replies
2
Views
271
PWD
PWD
PWD
  • Locked
  • Question
Query Filter to "End of Month Date Time" Web Intelligence Rich Client Version 12:4:0
Replies
3
Views
327
SkipVought
S
MaryMaryMorrison
  • Locked
  • Question
Export List of Bex Attributes from Query Designer
Replies
1
Views
246
MaryMaryMorrison
MaryMaryMorrison

Part and Inventory Search

Sponsor

Back
Top