Base a Calculation off Portal Row

[JoshPet]

Hi there, first question. FileMaker 6 on Mac OS X.

I've got one database (Line Items) in there is a field "Number Sold" which is a number and another one titled "Picked Up". It's a checkbox, value 1 if it's checked.

In another database (Sales) I've got a field which uses a calculation to SUM the Number Sold field from the portal rows. This works fine.

What I would like - is only have it sum the portal rows where "Picked Up" is checked ( = to 1). Any way to do that?

Thanks in advance.

[Fitch]

There are a couple of ways to do this. I think the easiest is to define a calc field in Line Items:

Case( Picked Up, Number Sold )

Now sum this field instead of the original.

[JoshPet]

Ah gotcha! Will give that a try.

Thank you.

[JoshPet]

Sorry for the late follow up- this works exactly like I want. I didn't know about "case()". Thanks much!