Help with inconsistent units in formula

Help with inconsistent units in formula

youssef.ibrahimM37J6
Advocate Advocate
4,413 Views
7 Replies
Message 1 of 8

Help with inconsistent units in formula

youssef.ibrahimM37J6
Advocate
Advocate

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!!

youssefibrahimM37J6_1-1688115606346.png

 

 

youssefibrahimM37J6_0-1688115591785.pngyoussefibrahimM37J6_2-1688115627767.png

 

 

0 Likes
Accepted solutions (3)
4,414 Views
7 Replies
Replies (7)
Message 2 of 8

L.Maas
Mentor
Mentor
Accepted solution

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.

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Message 3 of 8

youssef.ibrahimM37J6
Advocate
Advocate

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

youssefibrahimM37J6_0-1688126671274.png

 

 

youssefibrahimM37J6_2-1688126044738.png

 

0 Likes
Message 4 of 8

Mike.FORM
Advisor
Advisor
Accepted solution

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.

Message 5 of 8

kostask_oionei
Advocate
Advocate
Accepted solution

Hi,

take a look below. Both work.

 

2023-07-01_18-29-22.jpg


If my post help you, please give a like.
If your question was answered please mark it with ACCEPT SOLUTION. This helps others to find answers...


Kostas Kouris
Architect Engineer, M.Sc., ACI, ACP

Message 6 of 8

anze.kumar
Advocate
Advocate

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

Message 7 of 8

L.Maas
Mentor
Mentor

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

LMaas_0-1688636831215.png

 

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Message 8 of 8

youssef.ibrahimM37J6
Advocate
Advocate

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

0 Likes