2675193 - Planned days in "Time Account Snapshot" report show 0 for past records when no future planned leaves exist

• Planned days in "Time Account Snapshot" report show 0 for past dated records if there are no planned leaves in the future.  
• The calculated column "Planned Days" in the standard report "Time Account Snapshot" does not account for past dated planned leaves.

Story reporting

Advanced Reporting

1. Log in to the instance and run the Employee Central standard report "Time Account Snapshot".  
2. Set the current date to 27/07/2018.  
3. From Time Management, check the Time off data for a user as of 30/06/2018, which shows 10 planned days.  
4. Verify that as of 27/07/2018, the planned days are 0.  
5. Run the report "Time Account Snapshot" and provide the date range as 01/01/2018 to 30/06/2018.  
6. Observe that planned days appear as 0, while other fields like Balanced days, Taken days, and Earned days appear correctly based on the date filter.  

• The issue is caused by the token "today" and the operator "greater than" used in the calculated column "Planned Days".  
• Planned Days are calculated as bookingAmount multiplied by -1 when:  
  • bookingUnit = DAYS.  
  • bookingDate > TODAY.  
  • approvalStatus is APPROVED or PENDING.  
  • bookingType = EMPLOYEE_TIME. 

1. This behavior is expected, similar behavior is seen in Standard Story report
2. Planned days will only fetch data for future dated records and not for past dated records.

Time account snapshot, planned days, past dated record, Advance reporting, canvas, Story, report , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-EC-TIM , Time Off , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To