I have a "Calculated Value" in a schedule I use. It is called "Room Pressurization". Some values are +CFM, some are -CFM. Since I cannot use the conditional formatting for both positive and negative values (one color for positive, another color for negative) in the schedule, I tried to do a "Color Scheme". Now, I cannot create that same Calculated value.
Could you not just live with a single colour conditional format - if CFM<0 is red otherwise positive values are white?
My Room Pressurization Calc is a "Calculated Value" in one of my schedules. It does not show up as a useable parameter in the Color Schemes. It is "Actual Supply Airflow - Actual Exhaust Airflow" (there is no Return on this project). I also want to use multiple colors in negative and positive pressures.
Calculated Values do not leave the schedule. You can only add Project/Shared Parameters to the color scheme and you cannot apply formulas to those, so you're kinda S.O.L.
The only way you could do that is with manual work - add the Project Parameter to the Color Scheme and to your schedule and manually match the values. You can create an conditional format in the schedule to highlight the lines where the Calculated value does not equal the Project Parameter's value, but this cannot be an automated function.
Yeah, I kinda figured that. I could do a Positive and Negative pressurization Calc. Value, But I really want to display this on a Floor plan to see what's going on as far as adjacent rooms. Thanks for the Info, anyway.
Can I just add, this is an astonishing failure. When I first found out that Revit could do colour fill schedules based on parameters, I was over the moon - all our engineers could produce easy to read reports based on ACH/hour, CFM, positive / negative pressurization, the works! This would revolutionize how our company operates. All our engineering data could be stored in the space and we could access it and view it however we liked.
Then I found out that you can't add calculated parameters, so as far as we're concerned, the colour fill legends are pretty much useless, and by proxy so is much of the engineering functionality.
I hope there's a plan in the works to change this because I have never felt so frustrated with Revit in my life when I discovered this