Jump to content
martinfdc

Multiply two database cell values

Recommended Posts

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.

Database Multiplication.png

Share this post


Link to post

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

@Pat Stanford take a look at my record format, both values are stored as number: (tipo=type, número=number)

 

1744065577_RecordFormat.thumb.png.a473c643bc17e7f8c5fdfce3eb40f0ea.png

 

I also tried your formula but had no success:

formula.thumb.png.8bd94db5395cb0fd74fc611afa87802d.png

Share this post


Link to post

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.

  • Love 1

Share this post


Link to post
Posted (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). 

2063444057_datainreport.thumb.png.c9be28c476234f0e2ec4e9a34210f259.png

  

Edited by martinfdc

Share this post


Link to post
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
Posted (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?

359951472_placing1.thumb.png.2f471a5b562ce9f025611d365e31b313.png

 

Edited by martinfdc

Share this post


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

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

Share this post


Link to post

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

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×