Jump to content

Conditional Unstored Sums?


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

Recommended Posts

See attached file for an example of what the situation is.

We have a job list for our company that keeps track of orders for customers and orders for testing equipment comming in.

We have a field called "Total Sold"

This is a sum of the Child database job items.

Problem is, the sum is not stored, it is auto calculated on demand. The Thing is, I want to know how i can set up "Total Sold"

To calculate only the quantity of the companies who are NOT "Inventory Test"

Please help someone, our numbers are way out of wack. (We have items that we just got in, and we tested 300 of them , and only sold 5 so far, but our total sold is 305, it should only be 5 because the 300 extra came from the testing database)

When you look at the inventory table - you will see the total sold on the 4 test items.

X1111 Total Sold Should be 4

X2222 Total Sold Should be 1

X3333 Total Sold Should be 2

X4444 Total Sold Should be 5

Sum_Calculation_Problem.zip

Link to comment
Share on other sites

This topic is 6464 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
×
×
  • Create New...

Important Information

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