Multiply two database cell values

[martinfdc]

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.

[Pat Stanford]

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)

[martinfdc]

@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:

[Pat Stanford]

What are the formulas in B2 and C2?

[Peter Vandewalle]

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.

[martinfdc]

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, 2019 by martinfdc

[martinfdc]

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. 

[Peter Vandewalle]

Instead of =COUNT you can also just insert 1 into B2. No “=“ just the number 1.

[martinfdc]

@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, 2019 by martinfdc

[Peter Vandewalle]

Just put 1 and add values...

[martinfdc]

21 minutes ago, Peter Vandewalle said:

Just put 1 and add values...

Add values solved the issue once again. Many thanks.

[Pat Stanford]

Sum Values and Summarize Items can be confusing, but are very powerful once you figure them out.