Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. To access Analytics, in the top navigation, click Analytics. The Reports workspace appears.

  2. Select Voyage as the starting table from the report list. Filter to one voyage to start. You can expand the report to include more voyages as needed.

  3. Join the Voyage Pnl dataset to it.

  4. Select the snapshot date, snapshot type, data type (A for Actual, E for Estimated, or P for Posted if needed), the comparison basis to Actual values, the variances to include, and any additional information.

...

To get more granular data for the voyage P&L report, you can optionally join the following tables to the initial Voyage table:

Voyage Pnl Detail

...

Voyage Pnl Drilldown

...


Create a report using the Voyage PNL Summary dataset (one-to-many join from the Voyage table).

...

To get more granular data for the voyage P&L report, you can optionally join the following tables to the initial Voyage table:

  • Voyage Pnl Detail

...

  • Voyage Pnl Drilldown

...

Proration in P&L

The P&L can be prorated which means calculations will be divided in a proportional way based on the ranges you set.

  • The following are parameters for proration:

    • PeriodRangeGmt - a specified range that voyage overlaps

    • Portion % - shows how much of the voyage (commence-complete dates) overlaps the specified range;

    • Is Monthly - will break down each snapshot by months

    • Month - shows a specific month in that breakdown (it is recommended to format it as: MMM-YY)

    • PeriodOpsBallastDays, PeriodOpsPortDays and all other the portion-related columns

...