Custom measures - how to create calculated columns

Middle Office > Reports > Custom 

You can create your own calculated columns that will be available in all reports.

To add a column, click on Add:

1. Name: Give the column a name
2. Name UI: Is the name that will be shown in reports 
3. Data type
   1. System.Date time - Date format
   2. System.Int32- Integer (whole number)
   3. System.string- a text
   4. System.Int64- Integer (whole number)
   5. CRM.Finance.AssetAmount
   6. System decimal- number with decimals
   7. CRM.Finance.InterestRate
   8. CRM.Finance.Web.Models.Asset
4. Category
   1. Date
   2. MasterData
   3. Days
   4. Amount
   5. MarketData
   6. Status
   7. Bankinformation
5. Support Consolidated
6. Support Allocated
7. Support Realised
8. Aggregation operation
   1. Default
   2. None
   3. Totals
   4. Sum
   5. Average
   6. Count
   7. WeightedAverage
   8. Min
   9. Max
   10. Distinct
   11. CustomExpression
   12. PercentageOfTotal
   13. PercentageOfOtherColumn
9. Expression Editor
10. Is system restricted
11. Display format (Default Display)
    1. Date and Time
       1. D - Date
       2. T - Time
       3. F- Both date and time
    2. Numerics
       1. D-Integer
       2. Cx- Currencies, x is number of decimals.
       3. Nx- Number, x is number of decimals.
       4. Px -Percentage,x is number of decimals.