Jump to content

Calculation Issues


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

Recommended Posts

I have a file that I use to manage purchase orders. I want to have a field that calculates the total quantity of a certain product. ie on an order that has 3 different items I need a total quantity count on only the items that have the item# 13063. I'm sure this is easily done, but I am not very conversant with calculations unless they are very simple. Any help I could get would be greatly appreciated.

Link to comment
Share on other sites

Is it always going to be that specific item number? If so, you can create a second line item relationship (call it "LineItem13063") with the same criteria as your existing relationship, plus the added condition that item# = 13063, and then use the count function.

Count(LineItem13063::AnyField)

Link to comment
Share on other sites

  • Newbies

Similar to the previous solution.

Define a global field on the main table, this field will have a value list with the 5 different item numbers.

Then define a relationship from the main table to the line items

using gItemNumber = lineitem_itemNumber

And then the calc could be:

Count ( g_ItemNumber::item_number )

Hope it helps!

Everytime you select a different item number from the list you will get the count of how many orders have that particular item.

Link to comment
Share on other sites

This topic is 6463 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.