Calculated columns are created by applying functions to data fields. You use the Calc process object in the Visual Builder tab in much the same manner as the Visual Integrator Calc process object. For more information, see VI Calc Process Object.
Keep in mind the following:
- If the calculated column is based on a numeric info field, the new calculation is available at all levels.
- If a calculated field based on a numeric info field is created in ProDiver, the calculation is only available for the same dimension that the info field is based on.
Calculated columns can be used in Builder or ProDiver. An example of when to use a calculated column in Builder instead of ProDiver is a model that has Division and Contract as dimensions. The Contract dimension has two info fields: Workers and Number of Months. The info fields can be multiplied to give the calculation WorkerMonths per Contract. It does not make sense to sum the Months or Workers; however, it does make sense to look at WorkerMonths by Division. If the WorkerMonth calculation is created in Builder, it is available on the Division level. If it is created in ProDiver, it is only available on the Contract level.