Calculated Fields and Measures

You can create new fields or measures in an Ad Hoc view by applying formulas to a view’s existing fields and measures. For example, consider a view that includes both a Cost and a Revenue field. You could calculate the profit for each record by creating a custom field that subtracts the Cost field from the Revenue field. For example, you can divide the Profit custom field in the previous example by the Revenue field to express each record’s margin as a percent.

If you have installed the samples, the Ad Hoc view 10. Calculated Fields and Measures includes examples of calculated fields (shown by the icon ) or calculated measures (shown by the icon ). You can explore their formulas by right-clicking the field or measure name and selecting Edit. You can also create tables, charts, or crosstabs to see how these calculations work in views.