seattleflo Posted July 12, 2007 Share Posted July 12, 2007 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 Link to comment Share on other sites More sharing options...
Brett W Posted July 12, 2007 Share Posted July 12, 2007 don't really understand the question. are you trying to see another value list of related costs from the selection you make? Link to comment Share on other sites More sharing options...
seattleflo Posted July 12, 2007 Author Share Posted July 12, 2007 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 Link to comment Share on other sites More sharing options...
Brett W Posted July 12, 2007 Share Posted July 12, 2007 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 More sharing options...
Vaughan Posted July 13, 2007 Share Posted July 13, 2007 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 More sharing options...
seattleflo Posted July 13, 2007 Author Share Posted July 13, 2007 Many thanks to both of you for your help! You saved me... (= -Seattleflo Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now