Import a formula into a calculated metric definition
Directly import any formula that is stored in Microsoft Excel spreadsheets into a calculated metric definition. This import helps in quickly building your formula for performing calculations.
Before you begin
Role required: system admin
About this task
Sometimes, you might have a formula saved in a spreadsheet that you want to include into a calculated metric definition for use in formula building. In these instances, the formula import functionality proves beneficial. It's crucial to verify that the spreadsheet includes the following columns with precisely the same column names.
- Name
- Frequency
- Formula
- Calculation level
- Domain area
Procedure
Navigate to All > System Import Sets > Administration > Data Sources.
Select Metric definition data source.
Select the Manage attachment icon and upload the file that contains the formula.
Select the Load All Records related link.
Select Run Transform.
Select Transform.
Result
The calculated metric definition becomes available with the formula in the list of all the metric definitions.
Parent Topic:Formula building in a calculated metric definition