Custom Columns

Use this form to create additional reporting columns that are not available as existing pre-defined columns. You can create a custom column:

• With a date range that is different than the report date range. Alternatively, you can override the report date range and use a relative period, that is either based on Opening Balances or Current Reporting Year Begins.
• That calculates values based on the amounts from existing pre-defined columns, other custom columns, and user defined fields (UDFs).
• With variances that are otherwise not available, ratios based on actual amounts and UDF units, or variances that take budget version amounts into consideration.

Note: You cannot access this form until the report setup has been saved.

The following tabs are available on the Custom Columns form. Click the link to view detailed information about each tab:

• Custom Columns - Custom Column Tab
• Custom Columns - Date Override Tab
• Custom Columns - Formula Editor Tab