Which account type is intended for derived calculations within Cube Sheets?

The Cube Calculated Account is specifically designed for derived calculations within Cube Sheets. This account type allows users to create complex calculations that are based on other account values. It enables the combination of multiple data points and application of formulas to generate new insights or projections derived from existing data.

Cube Calculated Accounts provide flexibility in analysis by enabling users to define custom calculations that can be used for budgeting, forecasting, or analytical purposes. For instance, if you need to calculate a variance or create ratios, a Cube Calculated Account allows you to set these formulas within the Cube Sheet’s structure.

The other options do not fulfill this specific purpose. Standard Accounts are typically used for general entries of actuals or budgets, Dynamic Accounts are utilized for capturing fluctuating data that may change over time but aren't specifically for derived calculations, and Attribute Accounts store non-numeric data that provide additional context but do not perform calculations. Hence, the Cube Calculated Account stands out as the only option engineered for this specific need in Cube Sheets.