I’ve create a schedule with a YES/NO parameter as per my image below.
Now I need to setup a separate schedule that calculates the total yes selected, and finally a calculation that calculates the percentage..
For example:
Is this possible?
Solved! Go to Solution.
Solved by maciejwypych. Go to Solution.
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.
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