GP-Level Field

To modify GP-level fields, follow the below steps:

1. Navigate to Fin/KPI tab and click Edit. Fin/KPI Set-up Tab will be displayed. 


Navigate to GP Level panel.


2. Click on Add Field button in the top right corner of the panel.


3. The field will be activated. Enter the following details-

  • Field Name: To specify name of the field.
  • Field Type: To specify the field type, i.e. Income Statement, Cashflow Statement, Balance Sheet, KPI, or ESG.
  • Calculated: To specify if it is to be calculated or not. If you check the box, The Resultant field will auto select CALC value.
  • Formula: To add a formula for any calculated field, you must copy the exact name of already existing fields and use the mathematical operators like +,-,* etc. There should not be any space between the values.
  • Ordering: To specify the ordering. 
  • Indentation: To specify the indentation, 0, 1, and 2.
  • Resultant: To specify the operation, i.e. Sum, Average, CALC, Last Value, and First Value.
  • Data Type: To specify the data type, i.e. Currency, Non-Currency, or Percentage.
  • Include In Report: To specify whether the financials are to be included in report or not.
  • Comments: To specify comments. 

Note: To change the Field Ordering, you can use the drag and drop option. You can simply drag a field up and down to change its ordering.

4. Click Check () button to save the details. The added fields will appear in the Financials- GP Level Fields panel.


5. To edit a field, click on Edit () icon in the Actions column. Edit the details and click on Check () button to save.

6. To delete a field, click on Delete () icon in the Actions column. The delete window is displayed. Click OK to delete the field.


7. Click on generate GP Level Fields Template in the top left corner of the panel to bulk upload GP level Fields. 

8. Contact your system admin to bulk import GP Level Fields.
Copying Formula to Portfolios
To copy GP Level Field formulas to Portfolio, follow the below steps:
1. Click on Copy Formula to Portfolio(s) button () in the top left corner of the panel to copy GP Level Field formulas. A new window is displayed. 
2. Select/ Deselect the formulas you want to copy. Select Portfolio(s) to which you would like to copy the formulas. Click Update Formula(s) to copy them to the selected portfolios.


Copying Formula From Other Portfolios
To copy GP Level Field formulas from other Portfolios, follow the below steps:
1. Click on Copy Formula from Other Portfolio button () in the top left corner of the panel to copy GP Level Field formulas. A new window is displayed.

2. Select the Portfolio form the dropdown. Click on Update Formula(s). 

Verify Formulas
To verify the GP Level Field Formulas, click on Verify Formula button () in the top left corner of the panel.
The relevant fields will be activated.