Calculation field help - filtering out data

[ashill]

I have a layout to input travel expenses. The layout has a portal where each individual expense is entered.

Expense type | Date | Amt USD $ | Billing Type

Billing type is a drop down – either Reimbursable or Company Paid

I would like to have a total on the main layout of the reimbursable expenses and another for company paid expenses. I have only managed to create a total for both combined with a calculation field - unstored, =Sum ( Receipt_portal::USD )

Is there a way to filter out one of the billing types within the calculation or should I be looking elsewhere for a solution?

Edited September 30, 2010 by Guest

[comment]

Is this for display only, or do you need to use the result for something else too?

[ashill]

It is only for display.

[comment]

Define a summary field in the Expenses table as Total of Amount. Place this field on the "main layout" inside a one-line portal to the Expenses table. Filter the portal by:

Expenses::Billing type = "Reimbursable"

Use another portal (with the same summary field) for the other type.

[ashill]

Fantastic, thanks again for your help Comment. :smile2: