Room Schedule (Area) greater than requirement

[Yeu.Ng]

Hi all

Not sure you guys have encounter the below situation. 

I need to show the room area is greater than the requirement.

However, my issue is that I have a multiple room area called the store and combine must archive 6m²

So my formula is Area > Requirement

But when without itemize the area is greater than requirement but show No. (see screenshot)

I know what causes it but I not sure what is the solution to archive

my goal is to archive area > requirement when all same department room area is combine 

Bedroom combine is 24m² requirement is 25m²

Store combine is 6.5m² requirement is 6m² 

Thank you 

With itemizewithout itemize

[barthbradley]

Sounds like a rounding issue.  You can modify units/precision under "Field Format" on the Format tab.   

[ToanDN]

It is not easy to accomplish what you want in Revit because Revit can't do pivot tables like Excel. I can play around with formulas but no promises.

Attached is an example that involve some entering some data manually.

[Yeu.Ng]

Thanks. I will take a look.