Jump to content

Sum items from drop-down?


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

Recommended Posts

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

example.jpg

fields.jpg

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.