Description
I want to calculate the Cost per sqm of Areas in my project using the Zone tool in the Schedule.
Solution
Populate each room of the project with Zone.
Create a New Expression Based property.
- Go to Options > Property Manager.
- Select New > Change Property Name to Cost per sqm
- Change the Data type to Number and make sure to add its availability classifications to Zone. Select OK once done.
Create New Expression Based Property but this time, change its name to Area Cost.
- Go to Options > Property Manager.
- Select New > Change Property Name to Area Cost
- Change Data type to String and make sure to add it’s availability classifications to Zone.
Under Default Value, Select Expression > Add. Input the expression below:
CONCAT ( “$" , (STRCALCUNIT ( Measured Area * Cost per m2 )))
Select OK when done.
Add both Properties in the Schedule.
TIP: Since we have made the Total Cost property a “String” data type, it cannot show a sum value in the schedule. If you want to show the total cost, the property should then be in Number data type. To do this, we are not going to use any Operators and functions, instead, just simply multiply the Cost per sqm to the Measured Area. We will lose the symbol “$" by doing this. The expression now should look like this:
( Cost per sqm / 1 m^2 ) * (Measured Area)