Print Page - convert into months

Title: convert into months
Post by: kvchowdary on 17 Oct 2016 01:24:42 AM

Hi team,

I have one column in the report and its giving the output like..36 days 22 hours 16 minutes 30 seconds

The report expressin is like:[Pdate]-[sdate]/365.25*12

Now user wants the output like in months:36.9 like this

Cognos 10.2

Title: Re: convert into months
Post by: kvchowdary on 17 Oct 2016 02:30:42 AM

Hi all

I got the solution

Solution is:i have used the _days_between function

thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchowdary on 17 Oct 2016 01:24:42 AM