Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Calculate YES/NO parameter in a Schedule

4 REPLIES 4
SOLVED
Reply
Message 1 of 5
tonkata
1658 Views, 4 Replies

Calculate YES/NO parameter in a Schedule

I’ve create a schedule with a YES/NO parameter as per my image below.

 

SA.JPG

 

Now I need to setup a separate schedule that calculates the total yes selected, and finally a calculation that calculates the percentage..

 

For example:

 

SA-2.JPG

Is this possible?

 

4 REPLIES 4
Message 2 of 5
maciejwypych
in reply to: tonkata

Hi,

I "love" SEPP65 schedules 🙂
You can do it for the percentages, but it won't look "pretty".
Add a formula calculated value if(Solar Access 2hrs,1,0) 
Also add a formula calculated value with just 1 ( call it number one) and another percentage calculated value of number one
In formatting, change select calculate totals for all of the above.
In sorting choose sort by Solar Access 2hrs, select footer with totals and grand totals.
You'll get your calculations this way.



Message 3 of 5
maciejwypych
in reply to: maciejwypych

percentage calculation.JPG

 

Just following my previous post.
Column H - Yes/No parameter
Column I (you can hide it)- Calculated Value formula 1
Column J - Calculated Value formula if(3HOURS OF SUNSHINE,1,0)
Column K - Calculated Value percentage of number one.

Hope this helps

Message 4 of 5
tonkata
in reply to: tonkata

I'll try follow as best I can, might have a few question along the way.
Message 5 of 5
maciejwypych
in reply to: tonkata

See attached walkthrough

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Rail Community


Autodesk Design & Make Report