# Multi-criteria Sum

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

## Recommended Posts

I thought I figured this out, but actually I didn't. It could be quite simple.

I'm trying to have 2 criterias for my sum. (Category, Type)

I have a Sum d/b.

CategoryField= (Meat, Veggie, Milk, Carbo)

TotalCost_Expensive Field

TotalCost_Medium Field

TotalCost_Cheap Field

Portal Window(Everything d/:

In another d/b, called Everything d/b, I have a list of everything (This is a related file by CategoryField.)

CategoryField

TypeField = (Expensive, Medium, Cheap)

(The Type field applies to Meat, Veggie..etc)

CostField

Product

----------------------

Example:

*Sum d/b. Form 1.

Category: Meat

Portal row1: Product=Chicken; Type=Expensive; Cost=\$500

Portal row2: Product= Pork; Type= Cheap; Cost = \$200

Portal row3: Product= Beef; Type=Medium; Cost = \$400

Portal row4: Product= Shrimp; Type=Expensive; Cost= \$600

Total_Expensive = \$1100

Total_Medium = \$400

Total_Cheap =\$200

*In Everything d/b:

Record 1: Meat, Chicken, Expensive, \$500

Record 2: Meat, Pork, Cheap, \$200

Record 3: Meat, Beef, Medium, \$400

Record 4: Meat, Shrimp, Expensive, \$600

Record 5: Veggie, Carrots, Expensive, \$1000

-----------

I need to automatically calculate the

Total_Expensive, Total_Medium, Total_Cheap FOR that Category (Meat in this example) and to exclude Other Food Categories.

Total_Expensive = \$1100, and not \$2000.

Help!

Thanks!

##### Share on other sites

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

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,465 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,254 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,485 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,103 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,733 views
×
×
• Create New...