Jump to content

Issue with Calculated field that utilizes a summary field


This topic is 4403 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm having some issues with a calculated field....

I have a bunch of invoices with line items each line items has a number of boxes the items come in. I have a summary field that gives me total number of boxes in an invoice. Next I have a calcualted field that determines the number of pallets a given invoice will require based on the summary field.

When I put these fields into a sub-summary based on Invoice ID the summary of boxes field works correctly, but my pallet calculation gives me the total pallets for every invocie in the review. (IE its calculating based on the total boxes in the found set)

Not sure what going on here...

An example of my report (where you can get 4 boxes per pallet)

What I get:

Invoice Boxes Pallets

123 16 9

232 8 9

838 12 9

What I want:

Invoice Boxes Pallets

123 16 4

232 8 2

838 12 3

Link to comment
Share on other sites

This topic is 4403 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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