Author Topic: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES  (Read 155 times)

0 Members and 1 Guest are viewing this topic.

qui le

  • Mosquito
  • Posts: 3
HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« on: August 25, 2017, 02:06:28 am »
I have a ploblem about fomulas in revit quantities. as a attach image, i wan fomulars thk of duct, max(with,hight)>=450 is 0.8 thk, max(with,hight)>=900 is 0.9 thk, max(with,hight)<1800 is 1.2 thk, max(with,hight)>=1800 is 1.6 thk and max(with,hight)>450 is 0.6 thk.
ples help me, thanks all.

John Kaul (Se7en)

  • Administrator
  • Needs a day job
  • Posts: 8840
Re: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« Reply #1 on: August 25, 2017, 08:24:54 am »
The trick is to construct your conditions in reverse order like this:
Code: [Select]
if(or(Width > 1799, Height > 1799), 1.6,
        if(or(Width > 899, Height > 899), 0.9,
                if(or(Width > 449, Height > 449), 0.8,
                -469)))
       

However, please note that you will have to make this a one line formula and adjust it for the values you want. The above example is just a quickly typed template to get you started and to act as a visual aid.
“Common sense is not so common.” ~Voltaire

--> Donate to TheSwamp.org <--

qui le

  • Mosquito
  • Posts: 3
Re: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« Reply #2 on: August 27, 2017, 09:06:08 pm »
THANKS SO MUCH,
I DID

John Kaul (Se7en)

  • Administrator
  • Needs a day job
  • Posts: 8840
Re: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« Reply #3 on: August 28, 2017, 07:12:42 am »
Wonderful! Looks like a very nice schedule.

You are very much welcome.
“Common sense is not so common.” ~Voltaire

--> Donate to TheSwamp.org <--