Print Page - Crosstab Measure calculated not total

Title: Crosstab Measure calculated not total
Post by: chris2001dc on 20 Mar 2009 09:04:58 AM

Hi,

I am working with Cognos 8.3, I have a calculation in a crosstab and I want the totals to be calculted with the formula expresion but the crosstab aggregates de values.

The picture illustrates what I want.

The measure of the crosstab has this fÃ³rmula:
Measure = (Measure1/Measure2) / Factor

Please Help.

Thanks

Title: Re: Crosstab Measure calculated not total
Post by: blom0344 on 24 Mar 2009 03:34:05 AM

Will the calculated total make any sense if you use division by factor? (which factor anyway)

Title: Re: Crosstab Measure calculated not total
Post by: chris2001dc on 25 Mar 2009 08:18:53 AM

hi I used this formula and it worked

Total(current measure within detail [DATE])/[Factor]

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chris2001dc on 20 Mar 2009 09:04:58 AM