hello,
see screen shot. There is a calculated value that returns 1.275. This needs to read as 2, but instead it is rounded to 1, when using the Format of the field.
Any way to adjust this?
(Using the roundup() function in the calc. value formula does not work, it will return the units count)
Count doesn't work in formulas...Instead of Count use a project parameter = Integer ...
Otherwise, Calc. Value roundup works as such.. /1 *1
If it does not work in one go, do it in 2 stages (ie: 2 separate calculated values)
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
I assume they just want to round up the final total. If everything were rounded up they would have more than two.
@mhiserZFHXS wrote:
I assume they just want to round up the final total. If everything were rounded up they would have more than two.
I see what you mean.
and with a conditional format to mask the line items:
I think this may work, although it is tricky.
I will look into it, thank you,
gio
So, I think this is the formula that needs to be used to round up values (thank you ToanDN):
Count% * RoundUP( <whateverformual> / Count%)
It works in most cases, except when you are working with subsets of the total number of elements (not the Count% of all elements).
It would be nice a less cumbersome way to do this, but, again, it seems to work for most cases.
thank you
Regards
@gsucci wrote:
So, I think this is the formula that needs to be used to round up values (thank you ToanDN):
Count% * RoundUP( <whateverformual> / Count%)
It works in most cases, except when you are working with subsets of the total number of elements (not the Count% of all elements).
It would be nice a less cumbersome way to do this, but, again, it seems to work for most cases.
thank you
Regards
The issue is that you want to ROUND a value of Calculated Totals. For the time being, Revit cannot apply any math Function to a Calculated Totals value, only to actual rows' data. Percentage parameters are a means to bring the value of Calculated Totals back to the data rows so that Revit can process it.
If you have any specific case when it doesn't work, share it here and we will find out.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.