martinfdc 42 Posted August 30 Hi, I want to multiply two database values but I can't manage to do it. I attach a screenshot of the results I get. Share this post Link to post

Pat Stanford 593 Posted August 30 Almost certainly this means that one of the data values is stored as text instead of as a number. Try using a formula of =value(b2)*value(c2) Share this post Link to post

martinfdc 42 Posted August 31 @Pat Stanford take a look at my record format, both values are stored as number: (tipo=type, número=number) I also tried your formula but had no success: Share this post Link to post

Peter Vandewalle 7 Posted August 31 I see the value in A2 is summed. I suppose B2 has added values. You should also add values in D2. Otherwise you’ll get the unitary price. By the way you don’t even have to put a calculation in D2. Just the same formula as in C2 would do, just add the values. In a worksheet all rows are calculated and only after the row calculation sums and add values are calculated. This means that in B2 there will always be “1” so B2*C2 equals 1*C2 or just C2. After that calculation rows are summed and values added where this is asked. I hope this is clear. 1 Share this post Link to post

martinfdc 42 Posted August 31 (edited) 11 hours ago, Pat Stanford said: What are the formulas in B2 and C2? @Pat Stanford Many thanks for your help. The formula in B2 is COUNT and the formula in C2 is just reading a number value assigned to a symbol through a record format. I attach a screenshot of the report data. All I want to do is to multiply the number of items (from Count) x $ cost of each item (record format attached to symbols). Edited August 31 by martinfdc Share this post Link to post

martinfdc 42 Posted August 31 8 hours ago, Peter Vandewalle said: I see the value in A2 is summed. I suppose B2 has added values. You should also add values in D2. Otherwise you’ll get the unitary price. By the way you don’t even have to put a calculation in D2. Just the same formula as in C2 would do, just add the values. In a worksheet all rows are calculated and only after the row calculation sums and add values are calculated. This means that in B2 there will always be “1” so B2*C2 equals 1*C2 or just C2. After that calculation rows are summed and values added where this is asked. I hope this is clear. Many thanks @Peter Vandewalle, I did what you recommended and my problem was solved. I added the values in D2 and it worked. The result in D2 works either with a formula or with simply placing the same formula as in C2 and adding values as you say. I obviously prefer to go with the same formula as in C2 as it's easier and automated. Share this post Link to post

Peter Vandewalle 7 Posted August 31 Instead of =COUNT you can also just insert 1 into B2. No “=“ just the number 1. Share this post Link to post

martinfdc 42 Posted August 31 (edited) @Peter Vandewallebut I want to use count as this provides me with the number of items I have of that particular symbol. If I type count into B2 I simply get a 1quantity for all symbols. I want to know the number of symbols I have. Or am I doing something wrong? Edited August 31 by martinfdc Share this post Link to post

martinfdc 42 Posted August 31 21 minutes ago, Peter Vandewalle said: Just put 1 and add values... Add values solved the issue once again. Many thanks. Share this post Link to post

Pat Stanford 593 Posted September 1 Sum Values and Summarize Items can be confusing, but are very powerful once you figure them out. Share this post Link to post