This page describes how to create Calculated Attributes in dRofus. Using the Calculated Attributes feature, you can build formulas dynamically using available dRofus fields to create additional fields. Calculated Attributes are available for Rooms, Items, Occurrences, and Products and allow you to build simple to very complex results. We explain how to do this for Room Calculated Attributes, and on this page, we will go over how this can be done for items. The Calculated Attribute Formats are the same across dRofus. A good baseline understanding of how Item Composite Text Attributes work is a great place to start since the rules can be combined with these attributes. The Room Subtraction Example was simple, and the Item If/Then Example was more complex. The occurrence example we will go through here combines the features of calculated attributes across several modules, including rooms, items, products, and documents.
To create composite text attributes, you need superuser access to the database, as the setup is done in the Administration settings. Please refer to Project Administrator.
This feature can not be exported to xml or PDF, but is available in Excel Exports and Revit/ArchiCAD Add-On configurations.
Occurrence True/False and Value Example
In this example, we want to confirm that the product on an occurrence has two conditions before we can consider moving it forward into procurement. The first check is if the product has a document attached. The second is to make sure the product has a unit price. Since we are working with an occurrence, we know that a room and an item have been defined. This example is checking across several modules at once. Two fields were added: Has document (yes/no) and Unit price.
The first part is an if/then format that checks if the product has a document AND has a unit price greater than zero. If both are true, we return TRUE. If either is not valid, we return FALSE. The Data type is a Yes/No, so in the occurrence properties panel, we will see a check box under Product Documents Status within a new group called Validation Check. This could also be a column added to an occurrence list to quickly see which occurrences are ready for procurement or used in a report filter.
The most powerful feature of calculated attributes with occurrences is that you can access all room properties, room data fields, item properties, item data fields, product properties, product data fields, occurrence properties, occurrence data fields, documents, and image fields. There is an endless number of possibilities across all the Calculated Attribute Formats. We can’t wait to see what you uncover as you leverage this powerful feature.