Revit schedule calculation

Revit schedule calculation

Anonymous
Not applicable
1,092 Views
4 Replies
Message 1 of 5

Revit schedule calculation

Anonymous
Not applicable

Hello Group,

I am new still to formulas and need some assistance. I am trying to figure out how I can get two parameters to schedule out to calculate correctly in my schedule. I have two shared Parameters that I am trying to schedule, I have all my single boxes scheduling correctly but cannot get my double devices to add both parameters. I am not sure if I need to be using a "greater than" formula or a "if(and" formula. I have tried this so far, but its only calculates the one side"if(or(Box 1 UMA, Box 2 UMA), 1, 0)". With this I only get my "Box 1" to schedule I want both Box 1 and Box 2 to schedule as indvidual numbers and calculate both values together to give me a total.   

0 Likes
1,093 Views
4 Replies
Replies (4)
Message 2 of 5

barthbradley
Consultant
Consultant

A lot of info  -- but confusing.  Can you possibly post the RVT?  

0 Likes
Message 3 of 5

Anonymous
Not applicable

Not without giving up company policy. All I need is for all my Box 1's to calculate and all my Box 2's to calculate to give me one total. Some families will have both "Box 1 and Box 2" shared parameters nested in the family. I just can't get it the family with two parameters to give me 2. I am only getting to calculate 1 for both parameters.  

0 Likes
Message 4 of 5

barthbradley
Consultant
Consultant

well then, I'm lost.  

 

You say you have a formula written that is not working correctly -- if(or(Box 1 UMA, Box 2 UMA), 1, 0). What parameter type is "UMA".? On/Off?  And what kind of value is 1 or 0.  A number? So, if either box is checked return ; if neither box is checked return 0.  Yes? No? 

 

FWIW: the default for an On/Off parameter is NULL. It has no value whatsoever until it's activated by checking and unchecking the box.  Maybe that info helps. 

0 Likes
Message 5 of 5

ToanDN
Consultant
Consultant

If you already have Box a and Box 2 placed in the family why don;t you make them shared families and schedule the actual count?

 

And below is doing it with formulas:

Capture.PNGCapture1.PNGCapture2.PNGCapture3.PNG

0 Likes