count ([element] for report) is always 1

[Enrique]

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

[hespora]

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.

[Enrique]

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 :)