CUSTOMER ZONE

How can I format a report of vacation time off so that it shows vacation taken to date and future-dated vacation days as sepa

Find resources designed to help you get the most from Replicon

Summary:
I would like to setup a report in Web TimeSheet to show time off taken to date and future dated time off as separate columns.

Resolution:
The only report in Web TimeSheet that can be used to display time off taken to date and future dated time off as separate columns is Time Off Taken report. You can configure the report by including custom columns. Please find below the instructions to setup the report.

  1. Open the Time Off Taken report.
  2. Click the Settings button within the report.
  3. Scroll down to the bottom of the report and click the Add button under Custom Column.
  4. Add a custom column by name “Future Time”.
  5. Insert the formula If(StartDate < Date(2011,02,01),0,TimeOffDays).
  6. Add another custom column by name “Already Happened”.
  7. Insert the formula If(StartDate >= Date(2011,02,01),0,TimeOffDays).

If you want the report to display time off taken to date and future dated time off as separate columns, you can include today’s date in the Date field in the custom columns shown above.

Once you create the report, ensure that the Summary option is summing the columns.

 

Start a free Replicon trial today based on your business needs

Start Free Trial