COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rawata on 11 Jul 2015 12:54:21 AM

Title: Can't count months between two dates
Post by: rawata on 11 Jul 2015 12:54:21 AM
Please Help...

I Can't calculate months between two dates, so that i can calculate average for aggregate sales quantity..
Title: Re: Can't count months between two dates
Post by: MFGF on 13 Jul 2015 04:25:26 AM
Quote from: rawata on 11 Jul 2015 12:54:21 AM
Please Help...

I Can't calculate months between two dates, so that i can calculate average for aggregate sales quantity..

Hi,

Why can't you perform this calculation? Do you get an error? The wrong result? No result? Something else?

What expression are you using? I assume you are using a relational package not a dimensional package? Are you using the _months_between() function? Another method?

MF.