ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Export to Excel (Data only) does not show year on Quarterly TSVs


Article ID: 4297


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


When exporting records through ‘Export to Excel (Data Only)’ YEAR is not displayed in the Excel sheet if Period Type is set to Quarterly in the Time-scaled Value (TSV)

Steps to Reproduce:

1. Go to a portlet with the Export to Excel (Data only) option

2. Configure a TSV attribute to show Quarterly periods

One method to do this:

  • Select the Options drop down for the portlet, then Configure
  • Select 'Time-scaled Value'
  • Change Time Scale to 'Quarter'
  • Click 'Save and Return'
  • From the Options drop down select 'Export to Excel (Data only)' to export the data

Expected Results: The exported file shows the Quarter number and year (Example: Q2 2016, Q3 2016, Q4 2016, Q1 2017, Q2 2017, Q3 2017)

Actual Results: The exported file shows just the Quarter number but not year (Example: Q2, Q3, Q4, Q1, Q2, Q3)


This is caused by CLRT-80634


This issue applies to CA PPM 14.3 (and higher)


This issue is currently under review.

Workaround: Use 'Export to Excel' instead of 'Export to Excel (Data only)'. To do this: 

  • From the Options drop down for the portlet, select 'Export to Excel' to export the data.