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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Formula Calculation Based on Effective Dates
Thanks for the suggestion. I had not thought of that. Tony- TonyD88
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Formula Calculation Based on Effective Dates
I have a Sales table (CustCode, InvDate, InvNumb, InvAmount) that links to the Commission table (CustCode, CommissPerc, EffectiveDate) via CustCode. The report is for commissions by customer, and I am trying to calculate the commission percentage by multiplying the Sales_InvAmount by the...- TonyD88
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
