Jump to content

# 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.

#### 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)

I also tried your formula but had no success:

#### Share this post

##### Link to post

What are the formulas in B2 and C2?

#### 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.

• 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).

Edited by martinfdc

#### Share this post

##### Link to post
8 hours ago, Peter Vandewalle said:

I see the value in A2 is summed. I supp﻿ose B﻿2 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

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

#### 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?

Edited by martinfdc

#### Share this post

##### Link to post

Just put 1 and add values...

• 1

#### 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.

## 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.

×

• KBASE