Jump to content
Sign in to follow this  
seattleflo

Sum items from drop-down?

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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