- Forums Home
- >
- Revit Products Community
- >
- Revit Architecture Forum
- >
- Schedules quantitiy problem: Calculated Value = null + value

Community

Revit Architecture Forum

Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.
Translate

18 REPLIES 18

SOLVED
Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Message 1 of 19

Anonymous

5490 Views, 18 Replies

07-20-2017
02:41 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Not applicable

07-20-2017
02:41 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Hi every body,

Editing a quantity schedule I have this problem: I have the same info (length) in different parameters for different families.

I have tought to create another column with a formula with the sum of the two parameters (*Length = full_length + net_length* ).

I think that the problem is the value in the column of the parameter not present in the family. It is *null* and not *zero, *so the formula doesn't work.

Do anybody know a workaround of this issue?

Many thanks

I will aprreciate

regards

Lorenzo

Solved! Go to Solution.

07-20-2017
02:41 AM

Hi every body,

Editing a quantity schedule I have this problem: I have the same info (length) in different parameters for different families.

I have tought to create another column with a formula with the sum of the two parameters (*Length = full_length + net_length* ).

I think that the problem is the value in the column of the parameter not present in the family. It is *null* and not *zero, *so the formula doesn't work.

Do anybody know a workaround of this issue?

Many thanks

I will aprreciate

regards

Lorenzo

Solved! Go to Solution.

Solved by ToanDN. Go to Solution.

18 REPLIES 18

Message 2 of 19

07-20-2017
07:54 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Message 3 of 19

07-24-2017
08:02 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Hi Toan , thanks for the reply, but this formula doesn't work too.

I think because in the field of the parameter there is nothing (blank/null) and not zero. So the calculator can't make the sum... How can I do?

07-24-2017
08:02 AM

I think because in the field of the parameter there is nothing (blank/null) and not zero. So the calculator can't make the sum... How can I do?

Message 4 of 19

07-24-2017
08:40 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Can you share the file?

07-24-2017
08:40 AM

Can you share the file?

Message 5 of 19

07-24-2017
09:00 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

I could share it, but you won't be able to open it for another problem where you already helped me. With the modifications I made there is still some problems in the family that don't allow the opening of the model... 😞 😞 😞

07-24-2017
09:00 AM

Message 6 of 19

07-25-2017
03:52 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Did it!! YEeeah! I've created finally my super beam sysetm!

now... the schedule... here you can find the model...

for example I would like to create a unique column also for the weight.

One is in kilos [**weight_net]**, the other one is integer number [**Weight (g/piece)**].

I used this formula:

weight_net / 1 kg + [Weight (g/piece)] / 1000

The result is "0" for each row....

07-25-2017
03:52 AM

Did it!! YEeeah! I've created finally my super beam sysetm!

now... the schedule... here you can find the model...

for example I would like to create a unique column also for the weight.

One is in kilos [**weight_net]**, the other one is integer number [**Weight (g/piece)**].

I used this formula:

weight_net / 1 kg + [Weight (g/piece)] / 1000

The result is "0" for each row....

Message 7 of 19

08-02-2017
11:33 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Hi @Anonymous

We wanted to check back in with you on this post. How is everything working out?

See **HERE** for information on how to use the Calculated Value dialog to define formula driven reporting values.

Please mark **'Accept as solution'** for posts that helped solve your issue - this will help other users seeking similar solutions.

Thank you and we look forward to your reply update.

**Viveka CD**

Designated Specialist - AEC, AR/VR Research_{Autodesk playlists| Find Recommended Hardware| System requirements for Revit products| Contact Autodesk Support| Autodesk Virtual Agent| Browse Revit Ideas| Revit Tips/Tricks| Revit Help| Revit Books}

08-02-2017
11:33 AM

Hi @Anonymous

We wanted to check back in with you on this post. How is everything working out?

See **HERE** for information on how to use the Calculated Value dialog to define formula driven reporting values.

Please mark **'Accept as solution'** for posts that helped solve your issue - this will help other users seeking similar solutions.

Thank you and we look forward to your reply update.

**Viveka CD**

Designated Specialist - AEC, AR/VR Research_{Autodesk playlists| Find Recommended Hardware| System requirements for Revit products| Contact Autodesk Support| Autodesk Virtual Agent| Browse Revit Ideas| Revit Tips/Tricks| Revit Help| Revit Books}

Message 8 of 19

08-03-2017
01:05 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Hi Viveka!

I saw the learning about the calculated totals and I think I have understood. However... No, I didn't fix the problem yet.

If i didn't explain it properly I'll try again with a graph...

I have the schedule on the left and I would like to create another colum like the schedule on the right so I can hide the columns with less info.

I thought.. easy, just creating a calculated value named *length *(discipline:common, type:Length) ... and I used these formulas:

*net_length + full_length*

*(net_length/1) + (full_length/1)*

*(net_length/1 mm) + (full_length/1mm)*

But the result is always a blank cell.... I think because the solver is summing a "null value"(not zero) with a "length value"

I tried also itemize every family and not, calculating totals or not.. (without itemizing every family and calculating the total the result is zero instead null) dividing the parameter per 1mm, per 1,per 1000, per everything... but nothing

I have the same problem with the weight parameter.. I have some column in grams and other in kilos and I would like to unify them without using excel everytime to format the tab.

Where am I wrong?

Is it not commong to have different parameter of different families for the same info?

08-03-2017
01:05 AM

Hi Viveka!

I saw the learning about the calculated totals and I think I have understood. However... No, I didn't fix the problem yet.

If i didn't explain it properly I'll try again with a graph...

I have the schedule on the left and I would like to create another colum like the schedule on the right so I can hide the columns with less info.

I thought.. easy, just creating a calculated value named *length *(discipline:common, type:Length) ... and I used these formulas:

*net_length + full_length*

*(net_length/1) + (full_length/1)*

*(net_length/1 mm) + (full_length/1mm)*

But the result is always a blank cell.... I think because the solver is summing a "null value"(not zero) with a "length value"

I tried also itemize every family and not, calculating totals or not.. (without itemizing every family and calculating the total the result is zero instead null) dividing the parameter per 1mm, per 1,per 1000, per everything... but nothing

I have the same problem with the weight parameter.. I have some column in grams and other in kilos and I would like to unify them without using excel everytime to format the tab.

Where am I wrong?

Is it not commong to have different parameter of different families for the same info?

Message 9 of 19

Anonymous

in reply to:
Anonymous

09-04-2017
02:57 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Anybody? Any ideas?! no suggestion?

09-04-2017
02:57 AM

Anybody? Any ideas?! no suggestion?

Message 10 of 19

Anonymous

in reply to:
Anonymous

09-04-2017
08:09 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

why have you got two parameters (that are the same = length)? can you change the two different parameters to the same (=length) parameter?

09-04-2017
08:09 AM

Message 11 of 19

Anonymous

in reply to:
Anonymous

09-04-2017
08:36 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Because they come from different families and I thought it is faster using a formula in the schedule than changing the name of the parameters. Isn't it?

09-04-2017
08:36 AM

Message 12 of 19

Anonymous

in reply to:
Anonymous

09-04-2017
09:38 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

perhaps if you had built the models - maybe yes....... however cant help noticing these are manufacturers models? they may not (evidently dont) behave the way you might want or expect.

the manufacturer will almost certainly have put in protection for their property (intellectual)...... for instance a field you might expect to be a number they might have called text. a field you might expect to be a weight they might have called text. they might have one type configured to kilos another to grams.

they have all sorts of darstedly ways to protect their copyright - and why shouldnt they?!

maybe ask the manufacturer....;-)

09-04-2017
09:38 AM

perhaps if you had built the models - maybe yes....... however cant help noticing these are manufacturers models? they may not (evidently dont) behave the way you might want or expect.

the manufacturer will almost certainly have put in protection for their property (intellectual)...... for instance a field you might expect to be a number they might have called text. a field you might expect to be a weight they might have called text. they might have one type configured to kilos another to grams.

they have all sorts of darstedly ways to protect their copyright - and why shouldnt they?!

maybe ask the manufacturer....;-)

Message 13 of 19

09-04-2017
09:46 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Accepted solution

@Anonymous wrote:

Hi Viveka!

I saw the learning about the calculated totals and I think I have understood. However... No, I didn't fix the problem yet.

If i didn't explain it properly I'll try again with a graph...

I have the schedule on the left and I would like to create another colum like the schedule on the right so I can hide the columns with less info.

I thought.. easy, just creating a calculated value named

length(discipline:common, type:Length) ... and I used these formulas:

net_length + full_length

(net_length/1) + (full_length/1)

(net_length/1 mm) + (full_length/1mm)

But the result is always a blank cell.... I think because the solver is summing a "null value"(not zero) with a "length value"

I tried also itemize every family and not, calculating totals or not.. (without itemizing every family and calculating the total the result is zero instead null) dividing the parameter per 1mm, per 1,per 1000, per everything... but nothing

I have the same problem with the weight parameter.. I have some column in grams and other in kilos and I would like to unify them without using excel everytime to format the tab.

Where am I wrong?

Is it not commong to have different parameter of different families for the same info?

From your example, if "net_length" does not exist in Family A then the formula just simply does not work. If "net_length" exists in Family A but the value is Null then you need to change it to 0.

09-04-2017
09:46 AM

@Anonymous wrote:

Hi Viveka!

If i didn't explain it properly I'll try again with a graph...

length(discipline:common, type:Length) ... and I used these formulas:

net_length + full_length

(net_length/1) + (full_length/1)

(net_length/1 mm) + (full_length/1mm)

Where am I wrong?

Is it not commong to have different parameter of different families for the same info?

From your example, if "net_length" does not exist in Family A then the formula just simply does not work. If "net_length" exists in Family A but the value is Null then you need to change it to 0.

Message 14 of 19

09-04-2017
11:50 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

I think this is the correct answer.. the answer that i didn't want..

Thinking about it again it seems obvious.. if the parameter doesn't exist in one of the two families the formula simply doesn't work

So... in case I don't have the txt file of shared parameters I should create another one and assign it to the parameters I want with the same name. Am I right?

09-04-2017
11:50 PM

I think this is the correct answer.. the answer that i didn't want..

Thinking about it again it seems obvious.. if the parameter doesn't exist in one of the two families the formula simply doesn't work

So... in case I don't have the txt file of shared parameters I should create another one and assign it to the parameters I want with the same name. Am I right?

Message 15 of 19

12-26-2021
04:41 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Hello, Yes, to sum-up this discussion:

if the parameter doesn't exist in one of the two families the formula for computing data from both parameter groups from two families simply doesn't work ... which is problem for us- users of software.

The field of the parameter there is nothing (blank/null) and not zero. So the calculator can't make the sum =>** and software developers should think about this situation and give users chance to "avoid" of these parts of calculations (simply to change results e.g. to 0 instead of "null"). **

it is faster using a formula in the schedule than changing the name of the parameters. Isn't it? =>> Yes, of course it is much more faster ! I ask Revit developers to add this possibilty for creagng schedule formulas :

= either in way :

1) if parameter "not exist" in particular element as instance of particular family => keep it as 0 (or another preset value)

2) to see the created in formula parameter -> results based on particular element properties in the window for create multiple parameter : where I may glue together A1 ; A2 ; A3 etc. values (results) computed from the formula parameters, and shows up each time the one which exists (and the "null" ones will not show up).

**this is an improvement functionality request for Autodesk Revit developers**

**thank You **

**br, Richard and Martin**

12-26-2021
04:41 AM

Hello, Yes, to sum-up this discussion:

if the parameter doesn't exist in one of the two families the formula for computing data from both parameter groups from two families simply doesn't work ... which is problem for us- users of software.

The field of the parameter there is nothing (blank/null) and not zero. So the calculator can't make the sum =>** and software developers should think about this situation and give users chance to "avoid" of these parts of calculations (simply to change results e.g. to 0 instead of "null"). **

it is faster using a formula in the schedule than changing the name of the parameters. Isn't it? =>> Yes, of course it is much more faster ! I ask Revit developers to add this possibilty for creagng schedule formulas :

= either in way :

1) if parameter "not exist" in particular element as instance of particular family => keep it as 0 (or another preset value)

2) to see the created in formula parameter -> results based on particular element properties in the window for create multiple parameter : where I may glue together A1 ; A2 ; A3 etc. values (results) computed from the formula parameters, and shows up each time the one which exists (and the "null" ones will not show up).

**this is an improvement functionality request for Autodesk Revit developers**

**thank You **

**br, Richard and Martin**

Message 16 of 19

09-30-2022
09:32 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

The fact that this is still a fundamental problem in 2022 is unbelievable. This severely limits the usefulness of schedules.

09-30-2022
09:32 PM

Message 17 of 19

02-01-2023
09:21 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

2023 and still no improvement. It bewilders me that any time users ask for better modeling functionality, Autodesk responds, "Revit is really a database." and anytime we ask for better data management, Autodesk responds, "Revit is really a modeling software." get it together Autodesk.

02-01-2023
09:21 AM

Message 18 of 19

03-06-2023
07:17 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

I agree, this thread was started in 2017. 6 years later and absolutely no progress on this very simple ask. it's really disappointing that Autodesk doesn't seem to be interested in improving some of the most basic fixes that the community has been asking for...

03-06-2023
07:17 AM

Message 19 of 19

03-16-2023
06:05 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report

Hello everybody!

I created a post on Revit Ideas to solve this problem. Vote please!

https://forums.autodesk.com/t5/revit-ideas/calculated-values-considering-parameters-without-value-nu...

03-16-2023
06:05 AM

Hello everybody!

I created a post on Revit Ideas to solve this problem. Vote please!

https://forums.autodesk.com/t5/revit-ideas/calculated-values-considering-parameters-without-value-nu...

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Can't find what you're looking for? Ask the community or share your knowledge.