Hello,
I want to perform a distinct count of a
formula that can return a number, but it can't also return empty or zero. The problem is that I don't want to include the empty values in my distinct count.
Example:
my formula returns :
600601
600602
600603
null
null
My Distinct Count on this...
Yes, the sort executes correct for all records without the condition in the detail section. With the condition in the detail section the sort is only incorrect for the first block of records in the detail section.
Any clue why ?
Thx
Hi,
I have done the same thing in my report
I've addes a running total that counts records with each group. Then in the supress of my detail section I added the condition {#runtot} > 3.
Ok, I get only 3 records in my detail, but the problem is that in the first block of my report the sort...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.