Welcome to the Veson Nautical Knowledge Base. In the Help Center, you can view the same articles and contact support as needed.
IMOS On-Prem - Creating Custom Expressions in the Report Editor - Examples
Note: To create, edit, and copy Report Editor reports, the Report Editor (Legacy) - Create/Edit Reports Module Right must be selected for you in Security.
You can create custom report columns to display a value based on the values of other columns in the report, or a static value. For example, to add a column to display the value in the Cargo B/L Gross column multiplied by 3:
- Edit or create a legacy report from the IMOS Report List using the General Operations dataset.
- Add Cargo B/L Gross to the list of Report Columns.
- Under Specify custom expression columns, click Add New Column.
- in the Column Name field, type Cargo B/L Gross multiplied by 3.
- For Column Type, select Double.
- Click the Edit button to the right of the Column Expression field.
- In the Custom Expression Editor, type {Cargo B/L Gross} * 3Â and click OK.
- Under the new Column Name, click Apply and then click Yes. The new custom column is added to the Available Columns list.
- In the Available Columns list, select Cargo B/L Gross multiplied by 3Â and add it to the Report Columns list.
- Run the report and see that the new custom column values appear.
You could also use a Conditional expression in this case, following Microsoft Expression standards. For example, to display 0 in the custom column if the value in the Cargo B/L Gross column is greater than 30000 and 1 otherwise:
IIF ({Cargo B/L Gross} > 30000, 0, 1)
Still need help? Visit the Veson Nautical Help Center.
Copyright © 2017-2024 Veson Nautical LLC All Rights Reserved - Privacy Notice | End User Terms of Use