Print Page - count ([element] for report) is always 1

Title: count ([element] for report) is always 1
Post by: Enrique on 08 Nov 2016 04:27:53 AM

Hi experts!!

Today i bring a wierd question :

In a table like these (Query explore)

ISIN Car Color
A444 Mercedes Blue
A444 BMW Red
A444 Ferrrari Red
A444 Toyota Red

if i create a ne "Data item" and I insert "count ([ISIN] for report)" the result is always 1 and should be 4. I dont find eny explication to these, because
in others reports with nearly the same caracteristic the "count for report" work perfektly

I solved that problem with adding a new element with value "1" and another element that do the total... but i feel very confuesed about that

Does anyone have a clue? why that happens

Thanks in Advance, Enrique

Title: Re: count ([element] for report) is always 1
Post by: hespora on 08 Nov 2016 06:33:24 AM

This is a complete shot in the dark, but I have been able to replicate this by setting the aggregate function of the data item to count. It might just seem logical to someone to do this, but doing so actually turns it into a count of a count, and that would correctly be 1. Check if that is the case here, and if so, change the aggregate function to none.

Title: Re: count ([element] for report) is always 1
Post by: Enrique on 08 Nov 2016 08:00:47 AM

Hi hespora!!

thanks for your nice answer, but it´s not the case. I m wonder seriosly if its a problem with FM because it have nosense.

thanks again :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Enrique on 08 Nov 2016 04:27:53 AM