Calculations
It’s possible to calculate values for display, query upon or to set a category within a Cradle item. Calculations can perform basic addition, subtraction, multiplication and division.
Setup
- Open Project Setup and navigate to the Item Definitions section.
- Ensure you have categories set up to contain any inputs you require. In this example Width and Length of type Real have been added and also an additional category of Area also of type Real.
- Select the Item Types tab
- Add these categories to your item type, here it is to the Bedroom item
- Choose Calculations and add a New one, here called Floor Area
- Create the calculation, in this case multiplying [@CAT:Length] * [@CAT:Width] and set the output type to Real.
- Optionally set a category with the resultant value, in the example this is Area
- Save the schema and return to the main interface.
Run
- Edit the item to include values for the categories that are inputs to the calculation.
- Save the item and the calculation will be updated and in this case also set the associated category.
Related Articles
Rule Sets can be used to set values based on categories and calculations where the value is based on logic matching rather than on simply the mathematical result.
A quick way to see calculation values without changing the View or Form