Conditional formatting in schedule lights up when it shouldn't

[LOESCH_PK]

Hello everyone, got a tricky question.

I have this window schedule that compares the glazing area (custom shared parameter that is calculated within the family with various formulas depending on the type of glazing) of all windows within a room to the area of that room. The schedule is as i mentioned a WINDOW schedule with embedded room information. It firstly sorts by apartment number (with header) next by individual room, and displays information as follows: room area (set to calculate minimal) window types (field blank if types are various), glazing area (calculated sum), glazed area * 8 (according to polish building code, where the sum of glazing in a livable room should be 1/8 of it's area, ale calculated sum), the glazing area to room area ratio (conditional formatting set to lit up red if the ratio is less than 0.125), and an additional comment.

This works fine. The calculated values are proper. HOWEVER in an instance where the room has all its windows with an identical glazed area (they can be different types or families even) the conditional formatting lights up the field as red even if the ratio is high above 0.125. 

One more interesting thing. Before I set the room are to calculate minimal (which before done effectively multiplied the room are by the number of windows, which of course obstructed the results), rooms with these windows also also would light up red and give a wrong value. But since the calculations were fals anyway that is not all that important.

Any ideas to why this happens? The schedule serves it's purpose well enough but I like to be curious.

[Corsten.Au]

What happens when you change those two windows to some other type ( same area) ?

if there are calculated values in the schedule , have a in-depth look in what exactly it’s taking those

values from..

1. Room area : this cannot go wrong.. 

2. Windows : if there’s some value picked from windows family, make sure it’s correct

would definitely like to know more if this gets solved or not..

[LOESCH_PK]

Another type, family, that has an identical glazing area still causes the problem.

The values for the window glazing areas are correct. The problem might be somehow connected with the fact, that the room area is a "Minimal value", and the window glazing is a "calculated sum" in the formatting tab. I thought that maybe this problem is because a single window of this size wouldn't be big enough , but the final value is correct, and there are multiple instances of rooms, that if had only one window that wouldn't be enough, but the sum of a few windows gives a big enough value and it doesn't show in red.

I wanted to make this schedule not a window schedule, but a room schedule with embedded windows, but Revit ignores the "To-from" thingy in the window family and always assigns the windows to the outside room.

[Viveka_CD]

Hi @LOESCH_PK

It's been a while and I'm checking back on this issue.

Please share the file and journal if you would like me to investigate this behavior. I can send you a private folder if you'd prefer.

Looking forward to your reply update.

Regards,

[LOESCH_PK]

By "private folder" you mean a private way to send the file? I'd preffer that. How do I share the journal?

[cbcarch]

See if this helps:

https://forums.autodesk.com/t5/revit-architecture-forum/window-embedded-in-room-schedule-assigning-t...

[LOESCH_PK]

@cbcarch That is my thread, and it helped me make this schedule. But then the problem was scheduling the right windows with the right rooms, and I got it done. Now the problem is that a conditional format colours a field it clearly shouldn't 🙂

Thanks anyway.

[Viveka_CD]

Hi @LOESCH_PK

I have shared a private folder with you to upload your files. See HERE for information on how to locate your journal file.

Let me know if you have trouble accessing the folder. Looking forward to your reply update.

Regards,

[ToanDN]

---

@LOESCH_PK wrote:

Hello everyone, got a tricky question.

I have this window schedule that compares the glazing area (custom shared parameter that is calculated within the family with various formulas depending on the type of glazing) of all windows within a room to the area of that room. The schedule is as i mentioned a WINDOW schedule with embedded room information. It firstly sorts by apartment number (with header) next by individual room, and displays information as follows: room area (set to calculate minimal) window types (field blank if types are various), glazing area (calculated sum), glazed area * 8 (according to polish building code, where the sum of glazing in a livable room should be 1/8 of it's area, ale calculated sum), the glazing area to room area ratio (conditional formatting set to lit up red if the ratio is less than 0.125), and an additional comment.

This works fine. The calculated values are proper. HOWEVER in an instance where the room has all its windows with an identical glazed area (they can be different types or families even) the conditional formatting lights up the field as red even if the ratio is high above 0.125. 

One more interesting thing. Before I set the room are to calculate minimal (which before done effectively multiplied the room are by the number of windows, which of course obstructed the results), rooms with these windows also also would light up red and give a wrong value. But since the calculations were fals anyway that is not all that important.

Any ideas to why this happens? The schedule serves it's purpose well enough but I like to be curious.

---

It looks like identical windows got grouped into one row.  Does it show correctly if you ungroup them?

[FAIR59]

it can be done. see my reply to a similar question at https://forums.autodesk.com/t5/revit-architecture-forum/exterior-window-area-to-floor-ratio-calculat...

[LOESCH_PK]

@Viveka_CD I'm uploading the files right now. I think you should open the file with the "detach from central" option. When you open the file the the schedule should open up. If not, it's called "okno - Kontrola wielkości".

@ToanDN I've checked "itemize every instance". Everything seams to work as expected. The windows that didn't turn red now do, because every single one is too small for their room areas, but their sum is big enough, so when they are summed up (itemize every instance turned off) they don't turn red. 

The ones that do the problem are red all the time though their sum should be big enough.

@FAIR59 I checked your post and it's pretty much the same as I do, just simpler. And it doesn't exactly adres my question. But thanks anyway. 🙂

[BrendonLayCHT]

I'm doing the exact same thing and have a similar problem. Where I have window glazing vs room areas. I believe conditional formatting only works on individual instances of items. And not items sorted/grouped together in the schedules. It's a limitation of Revit that formulas and conditional formatting don't work on totalled columns, therefor if you have the same window type or instance Revit will group it schedule wise... I think