Jump to content
Sign in to follow this  
rservis

Cost breakdown

Recommended Posts

Hi All,

I need help in getting an Individual shipping cost.

My database has an order table and order line items table, 1 order can have multiple items on it. I get sent the Total Order cost which say is £15.00 and I need to break the total cost into however many items there are so that I can report on how much we have spent on x item. ie:there are 3 items on that order the individual cost would be £5.00 each.

I have a field called Total cost and Individual cost - is there a way to have it calculated automatically?

Many thanks

Roy

Share this post


Link to post
Share on other sites

Do you have an item table? - different then order line item table.

Ie. An inventory table where you store information about the items such as cost and vendor?

I have a field called Total cost and Individual cost - is there a way to have it calculated automatically?

What are you trying to calculate here? If you already have individual cost and total cost are you trying to get the number of items sold or are you trying to divide the total amount of the order with the number of the items sold to get the individual costs?

A little more info would be nice.

Disclaimer: Skill level Novice - just trying to help.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    jbante 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.