Sum items from drop-down?

[seattleflo]

Hi,

I am trying to calculate the total cost (sum) of the same items from a drop-down list.

For example, my drop-down list contains several items for invoice purposes:

(1) Salaries

(2) Contracts

(3) Services

Each item can have a varying price.

Example: In one invoice, (1) Salary may be $3000

In another invoice, (1) Salary may be $4000

I would like to create a calculation that says, "Across all invoices associated with a particular budget number I would like to know the total costs associated with that particular drop-down selection [(01) Salary], for example.

I have provided 2 images: One shows the layout and the other shows the field name.

Thanks so much for your help.

Regards,

Seattleflo

[Brett W]

don't really understand the question. are you trying to see another value list of related costs from the selection you make?

[seattleflo]

Hi,

I have attached my database/modules with a written explanation of what I am trying to do.

If it prompts that it can't find "Contacts" or "E-mail" you can ignore that.

Thanks so much for any help.

Regards,

Seatteflo

database_2.zip

[Brett W]

please take a look at the relationship graph and a few of the fields I adjusted, mainly the total fields next to the types and the grand total field at the bottom of the list. Because you had created a repeating field to store these values, the relational graph can get a little large. it might help if you type color and organize the graph a little better. but I started the first too, I think the rest you can handle.

database.zip

[Vaughan]

This could be done through a new relationship using a global field through which you can select the expenditure type. See the attached Expenditures file.

I notice that yout Budget Number is a repeating field. This is going to screw you very soon.

Expenditures.fp7.zip

[seattleflo]

Many thanks to both of you for your help!

You saved me...

(=

-Seattleflo