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

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

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

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

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

Many thanks to both of you for your help!

You saved me...

(=

-Seattleflo