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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to charge "X" for 1st item, then "X" for each additiona

Status
Not open for further replies.
joybee36

joybee36

Technical User
Feb 10, 2006
29
US
For example,

Again - we ship books.

The charge to ship the first box is $4.25, then it is $1.00 for each additional box. If I have a total of 10 boxes, (thanks lbass....), what formula should I use to calculate the total charge?
 
Sort by date Sort by votes
In the group footer or header where you are calculating the number of boxes in {@boxes} place a formula like:

{table.price1}+(({@boxes}-1)*{table.price2})

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Crystal Reports for Visual Studio 2022 Download
Replies
2
Views
2K
Joshua44
J
Maverick2021
  • Locked
  • Question
runtime error 20567 "page header/footer is larger than page"
Replies
0
Views
180
Maverick2021
Maverick2021
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
206
SoftwareRT
SoftwareRT
smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
212
hilfy
hilfy
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
368
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top