topic Re: Help with inconsistent units in formula in Revit Architecture Forum

Help with inconsistent units in formula

youssef.ibrahimM37J6 — Fri, 30 Jun 2023 09:00:40 GMT

As part of my schedule, I am trying to create a new parameter equal to elevation from level + 60000.

However, I am not sure what the problem is!!

Re: Help with inconsistent units in formula

L.Maas — Fri, 30 Jun 2023 10:45:08 GMT

I expect the elevation from Level has unit of length. Now you want to have a number. Revit does not know how to convert length to number.
Normally you can fix it by dividing. So "Elevation from Level/1 + 60000".
Basically Revit than will divide "Elevation from Level" by 1 (Revit assumes length unit) converting it to a number. Sometimes you have to play around with it or force it more (e.g "Elevation from Level/1 mm + 60000) to get it to work.

Re: Help with inconsistent units in formula

youssef.ibrahimM37J6 — Fri, 30 Jun 2023 12:04:34 GMT

Thank you @L.Maas for your reply, but the column return does not return anything in the cells

Re: Help with inconsistent units in formula

Mike.FORM — Fri, 30 Jun 2023 13:59:03 GMT

If you are making your calculated parameter a 'length' type you should not need to divide by 1.

You only need the division when you had it set to a 'number ' type so that it removes the units.

Re: Help with inconsistent units in formula

kostask_oionei — Sat, 01 Jul 2023 15:32:47 GMT

Hi,

take a look below. Both work.

Re: Help with inconsistent units in formula

anze.kumar — Sat, 01 Jul 2023 18:48:51 GMT

Take a look at your "Formatting" dialog in schedule -> maybe there is a problem there, as it is not showing any value in the schedule cell

Re: Help with inconsistent units in formula

L.Maas — Thu, 06 Jul 2023 09:47:56 GMT

I expect you have grouping on, "Itemize every instance" unchecked on the sorting tab of the schedule. In that case Revit will not automatically add up the values. On the Format tab you will have to activate a calculation method on that particular field to get values in the column

Re: Help with inconsistent units in formula

youssef.ibrahimM37J6 — Thu, 21 Sep 2023 15:55:24 GMT

@L.Maas and @kostask_oionei thank you it works fine now