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:
- Name: Give the column a name
- Name UI: Is the name that will be shown in reports
- Data type
- System.Date time - Date format
- System.Int32- Integer (whole number)
- System.string- a text
- System.Int64- Integer (whole number)
- CRM.Finance.AssetAmount
- System decimal- number with decimals
- CRM.Finance.InterestRate
- CRM.Finance.Web.Models.Asset
- Category
- Date
- MasterData
- Days
- Amount
- MarketData
- Status
- Bankinformation
- Support Consolidated
- Support Allocated
- Support Realised
- Aggregation operation
- Default
- None
- Totals
- Sum
- Average
- Count
- WeightedAverage
- Min
- Max
- Distinct
- CustomExpression
- PercentageOfTotal
- PercentageOfOtherColumn
- Expression Editor
- Is system restricted
- Display format (Default Display)
- Date and Time
- D - Date
- T - Time
- F- Both date and time
- Numerics
- D-Integer
- Cx- Currencies, x is number of decimals.
- Nx- Number, x is number of decimals.
- Px -Percentage,x is number of decimals.
- Date and Time
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article