Custom measures - how to create calculated columns

Created by Erik Akerlund, Modified on Mon, 20 Feb 2023 at 02:31 PM by Erik Akerlund

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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article