Fix calculated parameters

[Leopessoa_arq]

I've been trying to use calculated parameters on my sheets for a while and although Revit does not complain about my formula it does not calculate it either. Just for reference, the formula I've been trying to make work is a ratio between two areas (area1 / area2) output as a number.

Since this message has been moved to support by @kimberly_fuhrman-jones, I think it is best if I add here the details of the issue I've discussed with her. I've added a screenshot of the current scenario I'm facing below, a section of a title block family I've built myself (that is not an actual schedule but text fields and lines). The fields "Área do terreno" (site area), "Área construída" (built area) and "Área permeável" (permeable area) are all shared parameters of the type Area which have been added to the project information (as instance parameters and checked the "values can vary by instance group" box) so I could provide their values onto the project information box and retrieve them from the sheet family, those work just fine. The fields "C.A.", "T.O." and "T.P." are all ratios of the area in that same line by the "Área do terreno" (site area) field, all of them created straight into a text field inside the family using formulae. For example, "C.A." is given by this exact text in the formula "Área construída / Área do terreno" the result set to be of the type Number (Revit allows me to add the fields to the formula just fine but only accepts its return type to be Number or Integer Number, for all other types it presents an error).

[daniel_carlsonKVQA6]

O revit so calcula quando você tem as mesmas unidades. Uma dica é você dividir a unidade por 1. Exemplo, você tem 4 metro e quer multiplicar por 3 cm. dividi 4 por 1 metro e 3 por 1 cm, (4/1m)*(3/1cm). Vai ficar sem a unidade no caso, mas você consegue fazer contas com diferentes unidades na tabela. 

[Leopessoa_arq]

@daniel_carlsonKVQA6 é o caso de a Autodesk corrigir então, já que os dois parâmetros estão na mesma unidade (no exemplo que eu tenho, os dois são áreas em m²), mas a divisão de uma área por outra já vai dar algo sem unidade mesmo, ele até reclama se eu tento dizer que o resultado é outra coisa que não número, mas ainda assim não calcula. 

[barthbradley]

Why don't you just change the Formatting of the Percentage Value?

[Leopessoa_arq]

@barthbradley The issue is not with schedules but a title block family. I've added more details on the issue to the original post since it has been moved between forums.

[ToanDN]

The labels for the calculated values in the family must by a shared parameters.

[Leopessoa_arq]

@ToanDN These are.

[mariah.hanning]

Hello @Leopessoa_arq Kimberly was able to send me your sample file for investigation:

If the question is why does the parameter type need to be a number or integer; that's what results when you divide an area by an area. 

If the question is why is there a '?' when I try to enter a calculated value for the parameters like C.A., its because calculated values are looking for these parameters on the sheet, and not finding them because they are in project information. You can't calculate a parameter from project information, that looks to be a limitation currently.

If you apply the project parameters Área construída and Área do terreno to the sheets category, and enter the same values, you can then create the parameter in the title block for C.A. and have it a calculated function of Área construída / Área do terreno.

Each sheet is now going to have the parameters Área construída & Área do terreno, but it seems like you want one value for each of those per project, so in order to link them all together you will probably want to tie them to a global parameter so that if you update the global parameter, each sheet will update with the correct value. 

I have adjusted your project with C.A. set up like this as a sample, and am happy to send it over to you if that will be helpful. 

[Leopessoa_arq]

Thanks @mariah.hanning, that will surely be useful. Do you need me to send my e-mail in private to you or would you send me a download link in private?

However, I still think it would be more intuitive if calculated parameters could work with any data available to the family (in a broader sense than just a sheet), thus since the value of Área do terreno is obtainable from the sheet (or family) through a shared parameter, it makes no sense it cannot be used in a calculation, and thus a good reason why this deserves a little love from the dev teams.

[mariah.hanning]

@Leopessoa_arq I sent a link in private message, let me know if you run into issues with it. 

We will keep this in mind.