Forums >> Revit Systems >> Technical Support >> Need help with Summing yes/no parameters

AVSteve

active

Joined: Mon, Mar 17, 2008
19 Posts
No Rating

I need some help understanding conditional statements.  My desire is to have a parameter that will return the integer number of certain other parameters that are checked as 'yes'.  In other words, this summing parameters will return '3' when I have three of the five yes/no parameters checked as 'yes', then of course, when only one is checked as ‘yes’ it will return ‘1’. Any ideas?

Thank you for any help with this.

AVSteve 

This user is offline

AVSteve

active

Joined: Mon, Mar 17, 2008
19 Posts
No Rating

I just solved my own problem, with the help of google of course.

My example:

Up Throw = Yes

Down throw = Yes

Left Throw = Yes

Right Throw = Yes

 THEN

Throw = 4 = (if(Up Throw, 1, 0)) + (if(Down Throw, 1, 0)) + (if(Right Throw, 1, 0)) + (if(Left Throw, 1, 0))

AND

Up Throw = No

Down throw = Yes

Left Throw = Yes

Right Throw = Yes

THEN

Throw = 3 = (if(Up Throw, 1, 0))+ (if(Down Throw, 1, 0)) + (if(Right Throw, 1, 0)) + (if(Left Throw, 1, 0))

AND SO ON….

I hope this will help someone!

This user is offline

mhans

active

Joined: Tue, Nov 7, 2006
456 Posts

Hi,

Thanks for sharing your problem and solution. You should do that more often.

Mhans 

-----------------------------------

Motto: "No Post left behind"

This user is offline

Mystery parameters - shared?

1

Titleblock Parameters [ 1 2 ]

17

Instance Parameters in titleblock not linking

12

Shared or Project Parameters?

10

Shared Parameters - Schedules multiple parameters one column?

7