If you are unable to create a new account, please email support@bspsoftware.com

 

How to perform a date calculation in a crosstab

Started by acoates, 27 Apr 2017 11:01:46 AM

Previous topic - Next topic

acoates

Hello,

I'm wondering if anyone can help me perform a date calculation within a crosstab.

I'm able to perform the date calculation easily in a list report, by creating a data item that states [First Work Date] - [Open Date]. For a [First Work Date] of 14-Apr-2016 and [Open Date] of 13-Apr-2016, I return a response time of 1 day in the list report. When I do this same calculation in a crosstab, I return a response time of 12 days.

I'm performing this calculation for different regions, each region having multiple First Work Date's and Open Date's. So the calculation should be totaling all the First Work Date's for a region then subtracting all the Open Date's for that region to get a total response time. But this has not been the case.

I'm using Cognos Workspace Advanced on version 10.2.2.

Thank you!