ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Jasper Calculated Fields and Measures

book

Article ID: 214211

calendar_today

Updated On:

Products

CA Service Desk Manager CA Service Management - Service Desk Manager

Issue/Introduction

Guidance regarding calculated fields and measures in Jasper.

Cause

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.

Environment

CA Service Management 17.2 and higher

Resolution

If you have installed the samples, the Ad Hoc view Calculated Fields and Measures will provide many examples:

Additional Information

Calculated Fields and Measures

Attachments