Print Page - sum function in query layout

Title: sum function in query layout
Post by: div_1234 on 09 Sep 2011 02:10:09 PM

hi
i am using query layout ,its t supporting sum function,what is the alternate function available in cognos.

total([Query1].[Current] * _months_between('09/30/2010',[Query1].[acc] - 0.5))/[Query1].[Current]/12

it gives me error like function is not recognize at position '5'

Any help?

Title: Re: sum function in query layout
Post by: blom0344 on 10 Sep 2011 02:08:21 PM

_months_between('09/30/2010',[Query1].[acc] - 0.5)

This would require 2 true dates. I wonder whether subtracting 0.5 is allowed here?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: div_1234 on 09 Sep 2011 02:10:09 PM